Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spreadsheet-Salutation Column
I have a mailing list of 4000 doctors. Does anyone know
of a formula I can use to create a salutation column "Dear Last Name" without retyping all the names? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spreadsheet-Salutation Column
Pam
You don't say anything about the layout of your list. Let's say the last name is in Column B starting in B2. Let's also say you want your salutation to be "Dear Dr. Smith". In row 2 of some empty column, type the following formula: ="Dear Dr. " & B2 Note that there is a space after Dr. Drag this formula down Column B as far as your data goes. If you want to get rid of the formulas and retain the salutation, copy all the filled cells in the column that has the formulas. Then select the first formula cell in that column and do Edit - Paste Special, click on the Values radio button, Click OK. HTH Otto "Pam" wrote in message ... I have a mailing list of 4000 doctors. Does anyone know of a formula I can use to create a salutation column "Dear Last Name" without retyping all the names? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unhide column A of an excel spreadsheet? | Excel Worksheet Functions | |||
Turn off automatic change of mailname from salutation | Excel Discussion (Misc queries) | |||
want to ask salutation on a mailing list. | Excel Worksheet Functions | |||
How can I remove Salutation | Excel Discussion (Misc queries) | |||
How can I create a formula for Salutation | Excel Discussion (Misc queries) |