Hi

The only way to do that would be with a huge lookup table with all first
names in column A, and your designation of gender (as Mr or Mrs) in
column B.
Designate this table as Names

="Dear "&VLOOKUP(B1,names,2,0)&" "&B1&" "&C1

I still think you would have problems with this.
What about Alex? Is that Alexander or Alexandra, and i am sure there
will be many more cases where it wouldn't work.

Regards

Roger Govier



cs_vision wrote:

I am looking for a formula that will genderize the result. That is look at
the column with firstnames and put either Mr. or Mrs.

"Roger Govier" wrote:



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?