Splitting up a Cell's Contents

[Dennis Hughes]

I received a spreadsheet with close to a thousand names, email addresses,
and chapters all in the same cell, as in:
Smith,John,[email protected],ONT,VI

I'm running Excel 2003. Is there a way to use a formula to break this up
into different cells for last name, first name, email address and chapter?

I can do a search & replace the commas, if that is a help or do this in
stages.

Thanks,

Dennis

 

[Kevin H. Stecyk]

Dennis,

Here is one way.

1) Save your file as a text file (File1.txt)
2) Close your file
3) Open your file (make sure Files of Type is "All Files (*.*)" - Otherwise
the file doens't show up in the list)
4) Choose delimited, Next
5) Delimiters: Comma; Text qualifier: None - Finish

Hopefully that works for you.

Kevin

 

[Myrna Larson]

To work with the file you've already opened, select all of these cells (they
should all be in one column, right?), go to the Data menu, and select Text To
Columns. The Options are the same a Kevin mentioned -- delimited, with the
comma as the delimiter.

 

[Kevin H. Stecyk]

Hi Myrna,

To work with the file you've already opened, select all of these cells (they
should all be in one column, right?), go to the Data menu, and select Text To
Columns. The Options are the same a Kevin mentioned -- delimited, with the
comma as the delimiter.

That's a better solution than the one I gave. Thank you!

Best regards,
Kevin

 

[Dennis Hughes]

Thanks for the help. That worked very well and I've got it in my hints
file.

Dennis
===========================