Timbobaloba
asked on
Cleaning and sorting data
Hi Guys,
I have tens of thousands on entries in a pdf document that I need to sort. I can copy the data from pdf and paste it into excel. The data come in like this;
Column A Column B
Lastname, Firstname Suburb State
Lastname, Firstname Suburb State
Lastname, Firstname Suburb State
As you can see, the data comes in only the first column. I Need each word in its own column;
Column A Column B Column C Column D
Lastname Firstname Suburb State
Is this easy to do?
I have tens of thousands on entries in a pdf document that I need to sort. I can copy the data from pdf and paste it into excel. The data come in like this;
Column A Column B
Lastname, Firstname Suburb State
Lastname, Firstname Suburb State
Lastname, Firstname Suburb State
As you can see, the data comes in only the first column. I Need each word in its own column;
Column A Column B Column C Column D
Lastname Firstname Suburb State
Is this easy to do?
And Yes,
Excel 2010
It is under "Data" Menu
Sid
Excel 2010
It is under "Data" Menu
Sid
Data menu>Text to Columns
Keep Fixed width>next >next> finished
Keep Fixed width>next >next> finished
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1) Highlight Col A
Excel 2007
2) If you are using Excel 2007 then click on Data Tab. Under 'Data' Tab, select "Text To columns"
3) Select 'DeLimited'
4) Click Next
5) Click on 'Comma' under Delimiters and Click on Finish
Excel 2003
That option is under the "Data" Menu.
Hope this helps
Sid
Sid