If all of the values contain either a "B" or an "M", this will work.


=IF(ISERROR(FIND("B",A1)),MID(A1,2,FIND("M",A1)-2)*1000000,MID(A1,2,FIND("B",A1)-2)*1000000000)


If not, some tweaking will be needed.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398976