OK so for some reason Walmart.com has no way to export you receipts to a CSV, or anything for that matter, at least not that I'm aware of. I had a sheet that used to clean up my receipts, but I never really understood the formulas, and now it got messed up and I don't know how to fix it. Attached is the sheet I just deleted all the formulas cause I thought I'd start from scratch so I could understand them, but I'm at a loss here, can anyone help? As you could see in the attached sheet the 1st column is the raw data from the receipt copy/pasted from the website, the next 2 columns are the cleaned up DATA, i want to be able to just paste the raw DATA and gave it automatically clean up said DATA so then I could paste it on the second TAB.
Bookmarks