I am having trouble importing adresses from a word table.

hatingaz

New Member
Joined
Sep 20, 2006
Messages
3
I can't seem to get them into columns. I am saving as text and delimiting but it always imports into one row
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
It's difficult to help you without seeing a sample of your actual data. Please open your text file in Notepad, copy a few lines and paste them into your reply on the Board.
 

hatingaz

New Member
Joined
Sep 20, 2006
Messages
3
Arla Laflin
4153 W. Gary Dr.
Chandler, AZ 85226
Melissa Marie Leedom
5635 E. Bell Rd. #1037
Scottsdale, AZ 85254


I need each line of the address in a different column.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
To do that you will need to put it all on one line in your text file, with the elements delimited by eg a tab character.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,377
Members
410,679
Latest member
rolandbianco
Top