Hi There
I have one column with firstname and lastname, how do I create a username from the first letter of the firstname and the lastname, ie, Bill Smith = BSmith
Kind regards
BazzieB
Hello BazzieB, if A1 is the firstname and B1 is the lastname, then for cell C1 you could put this formula:
=CONCATENATE(LEFT(A1);B1 )
1 Like
Keeping only a compound name consisting of more than one names in their different roles may cause problems now and then.
However, if you assure the fomat to be OneWordGivenName OneSpace OneWordFamilyName, and if I may assume a case where this compound name is placed in A6, the abbreviated name will be returned by the formula
=LEFT(A6;1)&MID(A6;FIND(" ";A6)+1;999). If you want to assure the family names to be significantly shorter than 999 characters you may reduce that number. No need, however!