View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jwfakouri
 
Posts: n/a
Default formula containing text


=A1*B1
A1 contains "bla bla $15.75"....B1 contains "20"
I need the "bla bla" ignored and the answer of $15.75*20


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435
View this thread: http://www.excelforum.com/showthread...hreadid=511272