MrExcel Publishing
Your One Stop for Excel Tips & Solutions

merging mail to create mailing labels


Posted by Roy Hernandez on November 26, 2001 6:03 PM

Have directory in excel file broken up a different columns:

1 name (last name, first name)
2 address
3 city
4 state
5 zip

I am trying to create mailing lables but i want the first name first on the labels versus the last. Directory is huge and i want to avoid re-typing the first column.

Thanks, Roy


Posted by anno on November 26, 2001 6:46 PM

try =RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)(nt)

Posted by Bariloche on November 26, 2001 8:06 PM

Alternatively,

You can try:


=RIGHT($A1,LEN($A1)-FIND(" ",$A1,1)) & " " & REPLACE(LEFT($A1,FIND(" ",$A1,1)),FIND(" ",$A1,1)-1,1,"")

This will get rid of the comma. Just copy that formula down in a new column and you should be set.


take care

Posted by anno on November 26, 2001 9:10 PM

Re: Alternatively, oops - overlooked the comma thing. good pick up - thanks (nt)

: Have directory in excel file broken up a different columns

Posted by Bariloche on November 26, 2001 9:32 PM

anno, no problem. Just happened to have that formula from a few years ago (nt)