How can I create a formula for Salutation
 

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

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?

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

If the name is, say, in Cell A1, you can use this formula

\"DEAR \"&A1&\":\"

Hope this is what you need.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=474155

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?

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

"BenjieLop" wrote:


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

If the name is, say, in Cell A1, you can use this formula

\"DEAR \"&A1&\":\"

Hope this is what you need.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=474155

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?

Hi!

You can't do it for various reasons.

Some first names are not gender-specific (e.g. Evelyn).

Some names are not organised as first/last name as you expect. (e.g.
Chinese).

Some names will be of recent origin and not in any pre-existing
database. (After all, every name was new at some point in its history:
and you should see some of the neologisms I have seen...)

Best collect the salutation from the target: that way you stand a good
chance of getting it right.

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=474155