Text To Columns Command in Excel 2010 with Alt+Enter

CathyHosek

New Member
Joined
Nov 4, 2016
Messages
3
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!
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,406
Office Version
365
Platform
Windows
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).
 

CathyHosek

New Member
Joined
Nov 4, 2016
Messages
3
Thanks for the quick reply. I tried the ctrl+J and that worked. Have a great day, and I really appreciate your help!!
 

MickG

MrExcel MVP
Joined
Jan 9, 2008
Messages
14,841
Tick "Other" box and enter:-
Ctrl +J
Or hold down "Alt" key and enter 0010
 

Watch MrExcel Video

Forum statistics

Threads
1,099,005
Messages
5,465,959
Members
406,456
Latest member
jmishra91

This Week's Hot Topics

Top