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 )