+ Reply to Thread
Results 1 to 7 of 7

Add text prior to concatenate formula

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    Los Angels
    MS-Off Ver
    Excel 2011
    Posts
    3

    Add text prior to concatenate formula

    I am working on an excel guest list for an upcoming fundraising event. I am trying to concatenate the first and last name of each guest into one cell and add Mr. or Ms. to it before the names are combined. Any suggestions on how to do this?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Add text prior to concatenate formula

    How can you tell if the guest is male or female?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-05-2013
    Location
    Los Angels
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Add text prior to concatenate formula

    Unfortunately I have to go by the name. I do not have a column reserved to specify gender.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Add text prior to concatenate formula

    Sadly, I don't think Excel is going to be able to assess a cell value and determine if it is a male name or a female name. It's not always obvious to the human eye.

    Unless you have some viable means of selecting your variable, you have very little chance of doing what you want.

    Regards, TMS

  5. #5
    Registered User
    Join Date
    03-05-2013
    Location
    Los Angels
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Add text prior to concatenate formula

    Is there any way for me to manually type in the word Ms. or Mr. into a cell and follow it with concatenating the guests first and last names?

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Add text prior to concatenate formula

    Quote Originally Posted by TMShucks View Post
    Sadly, I don't think Excel is going to be able to assess a cell value and determine if it is a male name or a female name. It's not always obvious to the human eye.
    ..............
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Add text prior to concatenate formula

    Hi,

    In that case a simple

    =C1&" "&A1&" "&B1

    should do where Ms. / Mr. is in C1 and first/last names in A1&B1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1