Make an initial-and-surname username

Turn Ava and Reed into areed, a username idea for new accounts.

What you'll make

In Excel: Ava + Reed becomes areed.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1LEFT(TRIM(A8),1)The first letter of the given name."A"
2SUBSTITUTE(TRIM(B8)…)Adds the surname with its spaces taken out."AReed"
3LOWER( … )Makes every letter small."areed"

Read it left to right. The & joins the initial and the surname.

=LOWER(LEFT(TRIM(A8),1)&SUBSTITUTE(TRIM(B8)," ",""))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up names with the formula already in.
  2. Use your own names. Paste each given name into column A and each surname into column B of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Two people can get the same username, and hyphens or apostrophes stay in. Check before you use them.

Route: Get names ready for the letter

Microsoft's help: LEFT function