separate contents of one cell into multiple cells
 

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

separate contents of one cell into multiple cells
 

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

HTH
Regards,
Howard


"Horacio" wrote in message
...
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

separate contents of one cell into multiple cells
 

If always comma-delimited use DataText to Columns


Gord Dibben MS Excel MVP


On Sat, 23 Jan 2010 14:24:46 -0800 (PST), Horacio
wrote:

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

separate contents of one cell into multiple cells
 

On 23 Jan, 22:57, Gord Dibben <gorddibbATshawDOTca wrote:
If always comma-delimited use DataText to Columns

Gord Dibben *MS Excel MVP

On Sat, 23 Jan 2010 14:24:46 -0800 (PST), Horacio
wrote:



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

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

Horacio

separate contents of one cell into multiple cells
 

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.

Horacio wrote:

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

--

Dave Peterson