Forum Discussion

Debbie Fuller's avatar
Debbie Fuller
Copper Contributor
Jan 24, 2018
Solved

Excel formula/function question

I've been asked to build a function to produce unique client identifiers: The information needed is first and third letters of surname; first and fifth letters of first name, gender and date of...
Excel Desktop
Formulas & Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jan 24, 2018

    Debbie,

     

    may be something like this.

    =LEFT(A1)&LEFT(MID(A1,3,1)&2)&LEFT(B1)&LEFT(MID(B1,5,1)&2)&C1&TEXT(D1,"MMDDYYYY"
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jan 24, 2018

Debbie,

 

may be something like this.

=LEFT(A1)&LEFT(MID(A1,3,1)&2)&LEFT(B1)&LEFT(MID(B1,5,1)&2)&C1&TEXT(D1,"MMDDYYYY"
  • Debbie Fuller's avatar
    Debbie Fuller
    Copper Contributor
    Jan 24, 2018

    Thanks Detlef,

    It works. I am very grateful

Resources