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 )