Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cs_vision
 
Posts: n/a
Default 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?
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default

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?


  #3   Report Post  
BenjieLop
 
Posts: n/a
Default


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

  #4   Report Post  
cs_vision
 
Posts: n/a
Default

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?



  #5   Report Post  
cs_vision
 
Posts: n/a
Default

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




  #6   Report Post  
Roger Govier
 
Posts: n/a
Default

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?




  #7   Report Post  
AlfD
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Formula for calculating Little League Age... Brent Excel Worksheet Functions 1 September 21st 05 01:19 AM
how do I create a if-then formula? karen Excel Worksheet Functions 4 May 4th 05 12:08 AM
How to create specific formula STS Excel Worksheet Functions 4 May 2nd 05 01:44 AM
How do I create a formula that would allow me to subtract from a d Justlearning New Users to Excel 5 January 27th 05 10:47 PM
How do I create a formula in Excel that will countif or sumif bef. bkclark Excel Worksheet Functions 4 November 10th 04 06:30 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"