Address List

guamlenahans

Board Regular
Joined
Oct 25, 2006
Messages
113
I have a mailing list that is 1700 rows long. The list is 6 columns wide, with a column for first name, last name, adresss, city, st, and zip. To the last name column, I want to add the words "The" and 'Family", so that when I do the bulk mailing the mailing address will be, as example, The Smith Family, and not use the first name. Is there a way I could add the words to the last name column, or am I going to have to manually type in each row.

Thanks

Rob
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
20,642
Office Version
  1. 365
Platform
  1. Windows
Assuming that Column B contains the last name, try...

G1, copied down:

="The "&B2&" Family"

To convert these formulas into values, try the following...

1) Select the range of cells in Column G

2) Edit > Copy > Edit > Paste Special > Values > Ok

Hope this helps!
 

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
OR... Simply create the labels with the following layout:
The <LName> Family
<adr1>
<adr2>
<city>, <state> <Zip>
This would be done in Word during the excel data merge
and no formula would be needed. HTH Larry
 

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
Boy, did my last post get butchered! Layout should be:
The LASTNAME Family
ADR1
ADR2
CITY, STATE ZIP
Maybe it will be visible this time! Larry
 

Forum statistics

Threads
1,181,412
Messages
5,929,782
Members
436,689
Latest member
IbraheemWard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top