Home > Forum Home > Presenting and Reporting Data > Adding Spaces | Share |
Forum Topic | Post Reply Login |
Adding Spaces | Rate this: (2.5/5 from 2 votes) |
subject: Adding Spaces Hello I am trying to enter information off of a bank statement (in pdf) into excel and then transfer it into excel... My goal is to line up the date of the withdrawal with the description and the transaction amount MY GOAL is to get the data to look like this Columns:A B C 10-18 Verizon Wireless 71.71 10-18 Home Depot 34.51 10-19 Staples store 55.66 of Springfield 10-20 Office Depot 66.77 10-20 Shoprite of 88.88 Springfield 10-21 Prudential Insurance 500.00 The data is separated by tabs.Unfortunately, there are problems with the vertical spacing..if there is a double line, it all gets "smushed" WHAT I HAVE NOW: 10-18 Verizon Wireless 71.7110-18 Home Depot 34.5110-19 Staples store 55.66 of Springfield 66.7710-20 Office Depot 88.8810-20 Shoprite of 500.00 Springfield10-21 Prudential Insurance Is it possible to write a macro that will insert a blank space into column C for every time there is a blank space in column A... is it possible to make it such that, for every time a date is listed, in column A, the computer will output a number into column C (assuming i just list the numbers in column D, and the computer knows to select the first number in column D and then the next and so forth). Just an FYI:I used adobe professional to "copy as a table" the info from the bank statement, then paste into excel.. but it did not paste so neatly. From there, I copy and paste into quickbooks. I think this is the fastest way to type information from a scanned pdf bank statement into quickbooks. If there is a faster way, i would love to know how (Btw, i know of BRC, big red consultant, but i don't want to pay for that) Please let me know thanx jsvlad | ||
Posted by jsvlad on |
Replies - Displaying 1 to 2 of 2 | Order Replies By: Most Recent | Chronological | Highest Rated |
Rate this: (2.5/5 from 2 votes) | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Rate this: (3/5 from 1 vote) | |
DRPU Trade Label Software by https://www.tradelabelsoftware.com | |
Posted by TradeLabelSoftware on |
Displaying page 1 of 1 |
Find relevant Excel templates and add-ins for Adding Spaces in the Excel Business Solutions Directory |