Hello
I need help on very simple Excel question.
I have excel file exported from quickbooks which has buying cos
column: Here is some sample data

$0.04
$1.50
$1.135
$0.445*04
$0.01*EX
$0.02(some text)
$0.063 ES

I want to get only cost ( means I want to delete the strings after
"*", "(" , or space ).

Thank you in advance for your help!!!

Jaso

--
Message posted from http://www.ExcelForum.com