Hi, I'm using the following formula to generate user names in Excel:
=LEFT(A1,100) & B1
Forname in A1 and surname in B1
this is producing JoeBloggs: what I want is JoeB.
Any ideas how I can amend the formula so it extracts only the first letter of the surname?