Hi

I don't really understand your aim. Are you wanting to type LACK in a cell
and to return 2345? Or are you wanting to type 2345 into a cell and return
LACK? Or am I completely on the wrong tack? (pun intended!)

Andy.

"natei6" wrote in
message ...

=IF(ISNUMBER(A3),MID($G$1,A3/1000+1,1)&MID($G$1,MOD(A3,1000)/100+1,1)&MID($G$1,MOD(A3,100)/10+1,1)&MID($G$1,MOD(A3,10)+1,1)&MID($G$1,(A3-INT(A3))*10+1,1)&MID($G$1,ROUND((A3*10-INT(A3*10)),0)*10+1,1),"")

Hi to all,

My goal is a price code for cost of goods. In G1 I have "BLACKHORSE".
I need a code will convert 1 to B, 2 to L, BLA for 123 and so on. This
formula is giving me BBBLBB for 1. I don't need cents, just whole
numbers. Help with this code would be so appreciated.

Nathan Sargeant


--
natei6
------------------------------------------------------------------------
natei6's Profile:
http://www.excelforum.com/member.php...fo&userid=7185
View this thread: http://www.excelforum.com/showthread...hreadid=522990