Hi

With your names in column B, assuming them to be forenames, then
="Dear "&B1&","

If the names are last names, then if you had Title in another column,
say title in column A, Forename in Column B and Lastname in column C
="Dear "&A1&" C1"&","


Regards

Roger Govier



cs_vision wrote:

How can I create a formula that will look at the name in a column and create
a salutation?