Excel Spreadsheet-Salutation Column

P

Pam

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?
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Salutation Column in Excel Spreadsheet 1
Extract strings intelligently from single cell 0
letter salutations and envl. address. 1
can you capture info from a cell without retyping in another cell 1
Mail merge gender specific salutation 2
Help on mail 1
Designing Salutations in Access 2
Contains or Includes 10

Top