Text To Columns Command in Excel 2010 with Alt+Enter

[CathyHosek]

Good morning

I have a column containing:

Street Address (Alt+Enter for line break)
City State Zip (Alt+Enter for line break)
Country

I am attempting to use Text to Columns to break this entry to three columns, but cannot figure out how to use Alt+Enter as the delimiter.

Thanks in advance!

 

[FormR]

Hi, welcome to the forum.

When you get to the second step of text to columns, choose "Other" and with the ALT key pressed down enter 010 using the number keypad on your keyboard (not the numbers along the top).

 

[chicagocomputerclasses]

ctrl+J

 

[CathyHosek]

FANTASTIC!!!!! Thanks so much!!

 

[CathyHosek]

Thanks for the quick reply. I tried the ctrl+J and that worked. Have a great day, and I really appreciate your help!!

 

[MickG]

Tick "Other" box and enter:-
Ctrl +J
Or hold down "Alt" key and enter 0010