And one more...

=LEFT(A10,FIND(" $",A10))

Note the space just befor the $.

HTH
Regards,
Howard

"da" wrote in message
...
Hi
Is there anyway I can delete amount from each row using a formula?
I have over 600 transactions from which I need to delete amount.
thank you

2ND ST BISTRO POMONA, CA $23.38
7-ELEVEN 33242 ROSEMEAD, CA $5.15
7-ELEVEN 33242 ROSEMEAD, CA $7.00
99-CENTS-ONLY #0107 UPLAND, CA $4.23
99-CENTS-ONLY #0107 UPLAND, CA $6.00