Address List

[guamlenahans]

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

 

[Domenic]

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]

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

 

[guamlenahans]

Dom,

Worked like a champ, thanks!

 

[indiantrix]

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