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?
LVL 1
TimbobalobaAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
Oops I forgot to mention in Point 5 above that

5) Click on 'Comma' and 'Space' under Delimiters and Click on Finish

I have attached the snapshots so that you can see how it looks.

Sid
1.jpg
2.jpg
3.jpg
0
 
SiddharthRoutCommented:
Do this

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
0
 
SiddharthRoutCommented:
And Yes,

Excel 2010

It is under "Data" Menu

Sid
0
 
rjantonelliCommented:
Data menu>Text to Columns
Keep Fixed width>next >next> finished
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.