| Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > Removing tabs and spaces | Share |
Removing tabs and spaces
Excel Help for Removing Tabs And Spaces in Developing Business Administration Solutions
| Forum Topic | Login |
Removing Tabs And Spaces | Rate this: (3/5 from 1 vote) |
 |
This is a great tool if i can figure out how to do a couple of things. Each month I have sales reports for every day the Bar was open. These reports are PDF files. Below is a excert from the txt file that was created.
101 - System Tracking Food 27 216.29 Emp Disc 50% 0 0.00 0 0.00
Liquor 123 452.89 Manager Comp Open 0 0.00 0 0.00
Beer 59 178.81 Open Food Disc 0 0.00 Gift Cert Redeemed 0 0.00
Daquiri 131 690.99 Mgr Comp 100% 1 -93.08 Emp Charge 0 0.00
T-Shirt 0 0.00 Mgr Comp 50% 0 0.00 Total Other Payments 0.00 I need the following in a spreadsheet. Columns Results Food 216.29 Liquor 452.89 Beer 178.81 Daquiri 690.99 T-Shirt 0.00 Please let me know the best way to get these results. THank you for your help and for creating a great tool. | |
| Andy | ||
| Posted by andy16h on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Removing tabs and spaces in the Excel Business Solutions Directory |