Assuming all amounts start with a $, use the following formula:
=left(a1,find("$",a1)-1)

Regards,
Fred

"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