Add a period to a one-letter middle initial

Turn m into M. so middle initials look the same in every letter.

What you'll make

In Excel: m becomes M.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1LEN(TRIM(A8))=1Checks if the cell holds only one letter.Yes, one letter
2UPPER(TRIM(A8))Makes that letter a capital."M"
3&"."Adds a period after it."M."
4TRIM(A8)Otherwise keeps the cell, without stray spaces.Not used for row 8
5IF( … )Picks the initial with a period, or the cell as typed."M."

Read it left to right. Full middle names and initials that already have a period stay as typed.

=IF(LEN(TRIM(A8))=1,UPPER(TRIM(A8))&".",TRIM(A8))

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 middle names or initials into the green column of the Template tab. Fixed ones fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Only single letters change. Full middle names keep the capitals they were typed with, so check those.

Route: Get names ready for the letter

Microsoft's help: LEN function