My mailing list is set up . I need to reformat the columns for mailing labels.

Millrobin

New Member
Joined
Feb 23, 2019
Messages
9
A B C D E F G


J JAMES 242 6TH ROSEBURG OR 97471

I have a mailing list that is in Excel where each column has the full name, the street address, and the next column C has the city and state in one column. But for my label program I need the city and state separated. I have tried the find and replace to no avail.

I hate to resort to manually reformatting 900 addresses. Anyone have the answer?

Thank you!!!

Office 365, Excel
 
Last edited:

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

QuietRiot

Well-known Member
Joined
May 18, 2007
Messages
1,077
Can you do text to columns? Insert column after C, Highlight column C. Data > Text to Columns > Delimited > Space?
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,852
Office Version
  1. 2019
Platform
  1. Windows
If you load up a sample of your data, (4-6 records), I can show you how to do this in Power Query/Get and Transform. It is a simple procedure.
 

Millrobin

New Member
Joined
Feb 23, 2019
Messages
9
Full NameAddress CityZip
JAMESRUFENER225 PALMDALE AVEROSEBURG OR 9747197471
BRIANHENRY1327 NW GROVE STROSEBURG OR 9747197471
TERRYBROCK121 W CENTRAL AVESUTHERLIN OR 9747997479
KEITHSMETHERS9356 SOUTHBANK RDROSEBURG OR 9747097470
MICHAELWALTERS177 BEATTIE LANE ROSEBURG OR 9747097470
JOHNOSULLIVAN14271 N UMPQUA HWYROSEBURG OR 9747097470
WILLIAMBECHERER4395 HAPPY VALLEY RDROSEBURG OR 9747197471
KEITHJACKSON2940 N 47TH AVEOMAHA NE 6810468104
GEORGEWEBBER222 PALISADE DRROSEBURG OR 9747197471
DONJACKSON2683 SCOTTS VALLEY RDYONCALLA OR 9749997499

<colgroup><col span="6"></colgroup><tbody>
</tbody>

I am sure there is a way to paste an Excel example here. This is the best I could do. Please note there are 6 columns. The city state zip column needs to be 3 columns to work in the program I am using. In other words:
Full Name
Street Address
City,
State ,
Zip Code

Thank you!!!
Zip Code
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,879
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top