Excel Cells Question (IS This Possible)

[Guest]

OK, If you have trouble understanding this, e-mail me. OK

I have a list of 2000 names on an excel sheet. My list is 2000 Name, Colleges and High Schools of 2000 NFL Players. The information is all contained on one line within one cell. Example

Cell A1

Smith, John Miami St. John

This contains the last name, first name, college and high school of this person within the one cell. What I am trying to do it make it so each word appears in it's own cell. I wanted to do this without having to delete it and put each word in it's own cell. Is there a way I can reprogram it so it looks like Smith (Cell A1) John (B1) Miami (C1) St. (D1) Johns (E1) without deleting it and retyping it? Remember, I have 2000 of these, so I don't have time to retype them all. Any help is appreciated.

Someone I know said to import it as an eliminated file and then tell it to put each space in a new cell? Any ideas? THANKS!!

Evan

 

[Frank Kabel]

Hi
have a look dat 'Date - Text to Columns'. You probably have to use this
two times:
1. Divide the text separated with a coma in column A and B
2. divide the text separated with a space character

Note: It's a little bit difficult for schools which consist of two
words

 

[Guest]

Thanks for the reply. Confused on what I do with 'Date -
Text to Cloumns' and where I get this. Thanks!

Evan

 

[JE McGimpsey]

You can select more than one separator and run Text to Columns only once.

 

[Guest]

Where do I get these seporators and run them?

-----Original Message-----
You can select more than one separator and run Text to Columns only once.


.

 

[Frank Kabel]

Hi
sorry, a small typo. Should read:
goto the menu 'Data - Text to columns'

 

[Anders S]

Evan,

There is a typo in Frank's answer, it should read 'Data - Text to Columns', that
is choose 'Text to Columns' on the 'Data' menu. See Excel Help for details.
Text to Columns will probably do most of the work for you but IMO there is no
way to do this without afterwards examining each record and manually fix records
that don't fit the method (as Frank suggests).

Best regards
Anders Silven

 

[Greg]

1. Click the top of the column containing your data in order to select
the entire column.

2. Go to the "Data" menu and then select "Text to Columns".

3. Select "Delimited", then click "Next".

4. Select the checkboxes for both "Comma" and "Space", then click
"Next".

5. Click "Finish".

Your data will now be split into separate columns. You will need to
go back and clean up manually where you have a college, high school,
or a last name with that contains a space (like "Kansas St." or "Van
Pelt").

 

[Frank Kabel]

Hi JE
never thought of that. But after you pointed this out it seems quite
logical <vbg>