[Robert Morley]

Yeah, I've tried that, and it works to some degree, but it's a
less-than-perfect solution since it has no ability to merge multiple
consecutive piped lines into a single row, and also leaves a lot of spaces
in the table.


Rob

Suzanne S. Barnhill wrote:
Shouldn't even require VBA. Use Find and Replace to replace the +---+ lines
with nothing, then use Table | Convert | Text to Table separating at pipe.