separate contents of one cell into multiple cells

[Horacio]

Hi !

Is there a way to separate a content in one cell into mutiple cels??

I have this:

Portugal,KM25,2,euros,2002

what I´m looking for is separate all this between comma like Portugal
in one cell km25 in other cell 2 in other and so.

Thanks

Horacio

 

[L. Howard Kittle]

Try Text to column under Data (2003) using coma as the delimiter.

HTH
Regards,
Howard


Hi !

Is there a way to separate a content in one cell into mutiple cels??

I have this:

Portugal,KM25,2,euros,2002

what I´m looking for is separate all this between comma like Portugal
in one cell km25 in other cell 2 in other and so.

Thanks

Horacio

 

[Gord Dibben]

If always comma-delimited use Data>Text to Columns


Gord Dibben MS Excel MVP

 

[Horacio]

If always comma-delimited use Data>Text to Columns

Gord Dibben  MS Excel MVP

Thank you for the help I did not know this tool.

Horacio

 

[Dave Peterson]

If this is a single column, you can select the range (that single column) and
use:
Data|text to columns
Delimited (by comma)
and specify how each field should be treated.

I'd insert some columns to the right (first) so that I wouldn't overwrite them
with this parsed data.