How can I create a formula that will look at the name in a column and create
a salutation?
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 formulaOriginally Posted by cs_vision
"Dear "&A1&":"
Hope this is what you need.
Regards.
BenjieLop
Houston, TX
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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks