EXCEL: Separating data from 1 cell into multiple cells
 

I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into its
own cell.

Any suggestions?
Thanks,
Heather )

EXCEL: Separating data from 1 cell into multiple cells
 

Hi,
Highlight the column, Text to columns, Delimited, next, check only the Other
box and copy your | in the box beside it, next, finish

"HeatherJ" wrote:

I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into its
own cell.

Any suggestions?
Thanks,
Heather )

EXCEL: Separating data from 1 cell into multiple cells
 

Just in case you are having trouble finding the | to insert in the delimiter
box, it's the upper case of the key directly below the Backspace key on a
standard US keyboard. It shows as a vertical broken line on my keyboard.
(Lower case on that same key is the back-slash)

HTH
Regards,
Howard

"HeatherJ" wrote in message
...
I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into
its
own cell.

Any suggestions?
Thanks,
Heather )

EXCEL: Separating data from 1 cell into multiple cells
 

Thanks, perfect!

"Eduardo" wrote:

Hi,
Highlight the column, Text to columns, Delimited, next, check only the Other
box and copy your | in the box beside it, next, finish

"HeatherJ" wrote:

I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into its
own cell.

Any suggestions?
Thanks,
Heather )

EXCEL: Separating data from 1 cell into multiple cells
 

Called a "pipe"


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 07:44:07 -0800, "L. Howard Kittle"
wrote:

Just in case you are having trouble finding the | to insert in the delimiter
box, it's the upper case of the key directly below the Backspace key on a
standard US keyboard. It shows as a vertical broken line on my keyboard.
(Lower case on that same key is the back-slash)

HTH
Regards,
Howard

"HeatherJ" wrote in message
...
I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into
its
own cell.

Any suggestions?
Thanks,
Heather )

EXCEL: Separating data from 1 cell into multiple cells
 

I've never heard of that... thanks, learn something every day.

Howard

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Called a "pipe"


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 07:44:07 -0800, "L. Howard Kittle"
wrote:

Just in case you are having trouble finding the | to insert in the
delimiter
box, it's the upper case of the key directly below the Backspace key on a
standard US keyboard. It shows as a vertical broken line on my keyboard.
(Lower case on that same key is the back-slash)

HTH
Regards,
Howard

"HeatherJ" wrote in message
...
I have thousands of cells in a report with information that I need to
separate into different cells.

Ex. one cell: Arch | South | All Points | Extreme

I need an automated way to get each of the 4 names separated by "|" into
its
own cell.

Any suggestions?
Thanks,
Heather )