separate contents of one cell into multiple cells

  • Thread starter Thread starter Horacio
  • Start date Start date
H

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
 
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
 
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.
 
Back
Top