+ Reply to Thread
Results 1 to 3 of 3

Formula that will provide a text result from 3 different formulas

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    United States
    MS-Off Ver
    Office Professional 2013
    Posts
    2

    Formula that will provide a text result from 3 different formulas

    Hello Excel experts, I need your assistance. I seem to have forgotten how to write formulas today. I need to create unique identifier from existing data in the spreadsheet as follows: The month the individual was born, the day they were born, the year they were born, the first three letters of their last name and the first letter of their first name. I have the individual formulas, but am having quite the time getting them combined without an error message.
    Cells:
    A2: Last Name (example: Smith)
    B2: First Name (example: John)
    H2: Date of Birth (07-04-1976)

    Birthdate formula: =(text(H2,"MMDDYY"))
    First 3 of Last name: =UPPER(LEFT(A2,3))
    First Letter of First Name: =UPPER(LEFT(B2,1))

    Result should be as follows: 070476SMIJ

    How do I combine them into one cohesive formula? Please help.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Formula that will provide a text result from 3 different formulas

    Maybe?

    =(text(H2,"MMDDYY"))&UPPER(LEFT(A2,3))&UPPER(LEFT(B2,1))
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-16-2013
    Location
    United States
    MS-Off Ver
    Office Professional 2013
    Posts
    2

    Re: Formula that will provide a text result from 3 different formulas

    Thank you so much! You're the best NBVC!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. compare totals and provide a result
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2012, 08:17 PM
  2. Replies: 19
    Last Post: 01-05-2011, 10:03 AM
  3. Need a formula to lookup, compare, provide result
    By dklein2149 in forum Excel General
    Replies: 1
    Last Post: 02-06-2009, 12:55 AM
  4. How do I Provide a specific result given multiple criteria?
    By Barb Reinhardt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. How do I Provide a specific result given multiple criteria?
    By Luis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2005, 05:06 PM

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