Copy finished names as text

Paste Values turns formula results into plain names that won't change.

What you'll make

In Excel: Turns formula results into plain names.

How to paste values

NumberStepWhat to doWhat you'll see
1CopySelect the names in column C and copy them.A moving border
2Click D8Click the first empty cell for the copy.D8 selected
3Paste › ValuesHome › the arrow under Paste › Values.Ava Reed in D8
4CheckClick D8. The formula bar shows the name, not a formula.Ava Reed

Pasted names don't update when the first or last name changes. Paste again for fresh copies.

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 first and last names into the green columns of the Template tab. Then paste column C as values in column D.
  3. Hand it off. Column D is plain text. Copy it into your letter or send the file.

Before you send

Pasted names don't update. Make sure column C is right before you copy it, and keep the original columns.

Route: Get names ready for the letter

Microsoft's help: Paste options