In column (D) I have a variable range of data where some cells have data
which includes a "|" character.

I need a macro which runs down col D - until the last populated row in Col E
- and if there is a cell with a "|" it deletes the character and wraps the
text as if I pressed Alt+Enter on the keyboard.

I would really appreciate some help with the code especially how I replicate
the Alt+Enter part of the process as I am totally stuck.

Many thanks in anticipation