posted on January 19, 2006 08:20:45 AM new
Can someone help me with an excel formula? I have my archived sales downloaded, and I want the Credits column to be an actual number so that I can calculate sales tax. So I need the $ removed and the verbage to the right of the amount removed. SO that instead of $23.80 Paypal Payment #xxxxxxxxx is changed to 23.80
Is it possible that amount is there without all the garbage around it and I\'m just missing it?
Thanks
-from an excel challenged, screaming and pulling hair out, frustrated female