importing or converting data

[Guest]

I am not sure if this is the correct forum for my question but here goes:
I have a list of names separated by commas (,) in a txt file. Is there any
way to bring this into Excel with each word being in a separate cell
(preferably in one column)?

When I open this file in Excel 2002 they all go into the same single cell.

Example:
Bidusse, Bises, Bismot, Biton, Blanes, Bocara, Bocarra, Boccara, etc.

Thanks.

Jeff

 

[Don Guillett]

data>text to columns>delimited>>>>

 

[Guest]

Thank you.

data>text to columns>delimited>>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)