Using Find/Replace, you can use CTRL-j, or ALT-010 in the Find box and
then Replace it with something else (like "|") so that your text-to-
columns can parse on the replacement character.

Hope this helps.

Pete

On Jun 23, 5:05*pm, judykap wrote:
I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. *I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?