Creating User Names with Excel

Our usernames are a combination of the first initial of the first name and entire last name. Should there be a duplicate, we add a number. Below describes how to create the user names from a spreadsheet. However, care still should be given for those names that may contain a number. (e.g. Jack Johnson jjohnson and Joe Johnson jjohnson2)

Use CONCATENATE, LEFT, and LOWER to create user names.

Example: Don Ho dho

=LOWER(CONCATENATE(LEFT(C2,1), B2))

The formula returns 1 character of the word beginning on the LEFT in cell C2 joining it together with the entire word in cell B2. LOWER then converts the entire result to lower case.