Need help with Excel functions

Welcome Guest ( Log In | Register )

Need help with Excel functions, To find Gender using IC number Q&A

views

Flame Haze	Dec 27 2018, 03:27 PM Show posts by this member only \| Post #41
Enthusiast Senior Member 814 posts Joined: Oct 2009	QUOTE(rico_n @ Dec 27 2018, 03:25 PM) my case always position not fixed wan the formula in the spoiler not werking If you copy it straight the "" are a bit wrong Have to manually readjust it Try this » Click to show Spoiler - click again to hide... « =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"a",""),"b",""),"c",""),"d",""),"e",""),"f",""),"g",""),"h",""),"i",""),"j",""),"k",""),"l",""),"m",""),"n",""),"o",""),"p",""),"q",""),"r",""),"s",""),"t",""),"u",""),"v",""),"w",""),"x",""),"y",""),"z","")," ","") This post has been edited by Flame Haze: Dec 27 2018, 03:31 PM
Card PM	Report Top Like Quote Reply