Home > Forum Home > Presenting and Reporting Data > Adding Spaces Share

Adding Spaces

Excel Help for Adding Spaces in Presenting and Reporting Data


Forum TopicPost Reply Login

Adding Spaces

Rate this:
(2.5/5 from 2 votes)
Confusedsubject: 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 on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
You can use online tools for document conversion.
 DRPU Trade Label Software by https://www.tradelabelsoftware.com
 Posted by on
Oops
Rate this:
(2.5/5 from 2 votes)
The best option would be first to output your PDF to a text document.  Then in Excel import external data from text.  This will allow you to specify both the tab and other characters required to separate the values accordingly
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Adding Spaces in the