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 )