How do you split a column into two

Question

Level 1

0 points

How do you split a column into two

I have a huge list of names that ended up in one column. For example it says "John Smith" in one column. How do I put John in one column and smith in another without having to do each one manually?

Your help is much appreciated. Thank you.

imac, Mac OS X (10.5.7)

Posted on Jul 14, 2009 1:09 PM

Reply

Answer 1

KOENIG Yvan

Level 8

41,807 points

Jul 14, 2009 1:11 PM in response to Delancey

Look at:
http://discussions.apple.com/thread.jspa?threadID=2076683&tstart=0

Yvan KOENIG (from FRANCE mardi 14 juillet 2009 22:11:12)

Reply

Answer 2

Jul 14, 2009 2:00 PM in response to Delancey

Copy all the text into TextEdit , Pages or any other texteditor.

Select all the text and set up tabs on the ruler where you want the 2 columns to appear.

Search on the space between the "John" and "Smith" and replace it with a tab.

You can now copy and paste this into a Numbers table and it will fill the appropriate columns.

Peter

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Jul 15, 2009 2:14 AM in response to PeterBreis0807

PeterBreis0807 wrote:
Copy all the text into TextEdit , Pages or any other texteditor.

Select all the text and set up tabs on the ruler where you want the 2 columns to appear.

Search on the space between the "John" and "Smith" and replace it with a tab.

You can now copy and paste this into a Numbers table and it will fill the appropriate columns.

And if the entry is John Broadus WATSON you will get an odd result !

Yvan KOENIG (from FRANCE mercredi 15 juillet 2009 10:57:29)

Reply