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

[Millrobin]

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

 

[QuietRiot]

Can you do text to columns? Insert column after C, Highlight column C. Data > Text to Columns > Delimited > Space?

 

[alansidman]

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]

[TABLE="width: 384"]
<colgroup><col span="6"></colgroup><tbody>[TR]
[TD="colspan: 2"]Full Name[/TD]
[TD]Address [/TD]
[TD][/TD]
[TD]City[/TD]
[TD]Zip[/TD]
[/TR]
[TR]
[TD]JAMES[/TD]
[TD]RUFENER[/TD]
[TD="colspan: 2"]225 PALMDALE AVE[/TD]
[TD]ROSEBURG OR 97471[/TD]
[TD="align: right"]97471[/TD]
[/TR]
[TR]
[TD]BRIAN[/TD]
[TD]HENRY[/TD]
[TD="colspan: 2"]1327 NW GROVE ST[/TD]
[TD]ROSEBURG OR 97471[/TD]
[TD="align: right"]97471[/TD]
[/TR]
[TR]
[TD]TERRY[/TD]
[TD]BROCK[/TD]
[TD="colspan: 2"]121 W CENTRAL AVE[/TD]
[TD]SUTHERLIN OR 97479[/TD]
[TD="align: right"]97479[/TD]
[/TR]
[TR]
[TD]KEITH[/TD]
[TD]SMETHERS[/TD]
[TD="colspan: 2"]9356 SOUTHBANK RD[/TD]
[TD]ROSEBURG OR 97470[/TD]
[TD="align: right"]97470[/TD]
[/TR]
[TR]
[TD]MICHAEL[/TD]
[TD]WALTERS[/TD]
[TD="colspan: 2"]177 BEATTIE LANE [/TD]
[TD]ROSEBURG OR 97470[/TD]
[TD="align: right"]97470[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD]OSULLIVAN[/TD]
[TD="colspan: 2"]14271 N UMPQUA HWY[/TD]
[TD]ROSEBURG OR 97470[/TD]
[TD="align: right"]97470[/TD]
[/TR]
[TR]
[TD]WILLIAM[/TD]
[TD]BECHERER[/TD]
[TD="colspan: 2"]4395 HAPPY VALLEY RD[/TD]
[TD]ROSEBURG OR 97471[/TD]
[TD="align: right"]97471[/TD]
[/TR]
[TR]
[TD]KEITH[/TD]
[TD]JACKSON[/TD]
[TD="colspan: 2"]2940 N 47TH AVE[/TD]
[TD]OMAHA NE 68104[/TD]
[TD="align: right"]68104[/TD]
[/TR]
[TR]
[TD]GEORGE[/TD]
[TD]WEBBER[/TD]
[TD="colspan: 2"]222 PALISADE DR[/TD]
[TD]ROSEBURG OR 97471[/TD]
[TD="align: right"]97471[/TD]
[/TR]
[TR]
[TD]DON[/TD]
[TD]JACKSON[/TD]
[TD="colspan: 2"]2683 SCOTTS VALLEY RD[/TD]
[TD]YONCALLA OR 97499[/TD]
[TD="align: right"]97499[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Millrobin]

Do I download the Power Query for Excel?

 

[Millrobin]

Good idea. I will try that now. Thanks.