EXCEL: Separating data from 1 cell into multiple cells

[HeatherJ]

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 ([email protected])

 

[Eduardo]

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

 

[L. Howard Kittle]

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]

Thanks, perfect!

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

 

[Gord Dibben]

Called a "pipe"


Gord Dibben MS Excel MVP

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

 

[L. Howard Kittle]

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

Howard