Shikha Rathi
Reputation: 1
Combine last name and initial of first name in excel - format of the word is "last name, first name" in single cell
I want to create user Id using "Initials of first name.last name", the format of the word is "last name, first name" in single cell.
Column D - Smith, John
Result - J.Smith
I used = =PROPER(TRIM(LEFT(SUBSTITUTE(D3," ",REPT(" ",99)),99))&"."&RIGHT(D3,(LEN(D3)-FIND(", ",D3)-1)))
Please help. Thanks in advance.
Upvotes: 0
Views: 971
Answers (1)
user4039065
Reputation:
Try,
=MID(D3, FIND(",", D3&", ")+2, 1)&". "&LEFT(D3, FIND(",", D3&",")-1)
Upvotes: 3
Related Questions
- Make a username from a full name using first initial and last name
- Combine First and Last name into full name (VBA)
- Reformat name in cell to First Initial. Last Name in Excel VBA
- Insert space before middle initial name
- Excel formula to rearrange LastName, Firstname MiddleInitial to FirstName Lastname
- Separate Full String into Firstname, Middle Initial and Lastname by column
- separate Last Name, First Name and Middle Initial in three different columns
- Add a full stop between user's first and last names
- In Excel.. How do take the first letter of a name and add it to their last name in another column
- How to create account name from LastName, FirstName in excel