text to column with embedded special character

E

Eddy

I am trying to parse the text below using the text to
columns using the semi-colon as the delimiter, but there
is an embedded "enter" character in the text and the
parser doesnt see the second line.

"Patch 1C-1;
Patch 1C-2"

Any Ideas?
 
Top