In this example the formula takes the user's full first name and surname initial to make a username
=CONCATENATE(B1,LEFT(C1,1))
Where B1=first name and C1 = last name
How to Concatenate Cell Data - Usernames Print
Modified on: Wed, 3 Feb, 2021 at 10:16 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.