On Aug 20, 8:13 am, Challenger
wrote:
How do I remove the delimiter? How are you typing the vertical line character?


If you use Text to Columns, whatever delimiter you use will vanish.
You can use more than one, if you need a space or comma to separate
some columns, too. Otherwise, the formula I wrote before will get rid
of it and put in whatever text you want.

It's simple to type, surprisingly, but sorta hidden. The bar is
usually right above the Return/Enter button on a USA keyboard. It is
pictured as a broken line, but Windows actually types the solid line.
aka SHIFT-backslash.