How to Prefix a Name in Excel or Google Sheets

by

Adding a prefix to a name sounds tiny. But it can save a lot of typing. Maybe you need Mr., Ms., Dr., Prof., or even a fun tag like VIP. Excel and Google Sheets can do it in seconds. No magic wand needed. Just a few simple formulas.

TLDR: To prefix a name in Excel or Google Sheets, use a formula like ="Dr. "&A2. The prefix goes in quotes, and the name cell comes after the ampersand. Remember to add a space inside the quotes, or your result will look squished. You can then drag the formula down to apply it to many names.

What Does “Prefix a Name” Mean?

To prefix a name means to add something before the name.

For example:

  • John Smith becomes Dr. John Smith
  • Maria Lopez becomes Ms. Maria Lopez
  • Sam Green becomes VIP Sam Green

That little word or title at the start is the prefix. It sits in front like a tiny name hat.

You can add the same prefix to every name. Or you can use different prefixes from another column. Both are easy.

Method 1: Use the Ampersand Formula

This is the simplest method. It works in both Excel and Google Sheets.

Let’s say your name is in cell A2.

In cell B2, type this:

="Dr. "&A2

Press Enter.

You will get:

Dr. John Smith

Here is what the formula does:

  • "Dr. " is the prefix.
  • The space after the period is important.
  • & joins text together.
  • A2 is the cell with the name.

Think of the ampersand as glue. It sticks the prefix and the name together.

Do Not Forget the Space

This is the most common little mistake.

If you type:

="Dr."&A2

You may get:

Dr.John Smith

That looks awkward. Poor John is trapped next to the period.

Use this instead:

="Dr. "&A2

Now the result is clean:

Dr. John Smith

The space lives inside the quotation marks. Small space. Big difference.

Method 2: Prefix Many Names at Once

You probably do not have just one name. You may have a whole list. No problem.

Here is the setup:

  • Names are in column A.
  • Your formula is in column B.
  • The first name is in A2.

In B2, enter:

="Ms. "&A2

Then use the fill handle.

The fill handle is the tiny square at the bottom-right corner of the selected cell. Click it. Drag it down. Excel or Google Sheets will copy the formula for each row.

It feels like teaching a spreadsheet a dance move. It repeats it perfectly.

Method 3: Use a Prefix from Another Cell

Sometimes each person needs a different prefix.

Maybe your sheet looks like this:

  • Column A has the prefix.
  • Column B has the name.
  • Column C will show the final result.

Example:

  • A2: Dr.
  • B2: Priya Shah

In C2, type:

=A2&" "&B2

The result will be:

Dr. Priya Shah

This formula joins three pieces:

  1. The prefix in A2
  2. A blank space
  3. The name in B2

This is very handy for mail lists, class lists, staff records, and event badges.

Method 4: Use CONCAT

You can also use the CONCAT function. It joins text too.

In Excel or Google Sheets, type:

=CONCAT("Mr. ",A2)

This gives you:

Mr. John Smith

It is a bit more formal than the ampersand method. But it does the same job.

If your prefix is in another cell, use:

=CONCAT(A2," ",B2)

This combines the prefix in A2, a space, and the name in B2.

Method 5: Use TEXTJOIN for Cleaner Results

TEXTJOIN is great when you want to combine text with a separator.

Use this formula:

=TEXTJOIN(" ",TRUE,A2,B2)

This means:

  • Use a space between items.
  • Ignore empty cells.
  • Join the prefix and the name.

This is useful if some people do not have a prefix. The formula can skip blanks and keep things tidy.

For example, if A2 is blank and B2 says Ella Brown, the result stays neat:

Ella Brown

No weird extra space. No spreadsheet goblins.

Method 6: Google Sheets ArrayFormula

Google Sheets has a fun trick called ARRAYFORMULA. It can apply a formula to a whole column at once.

If your names are in A2:A, use this in B2:

=ARRAYFORMULA(IF(A2:A="","","Dr. "&A2:A))

This says:

  • If the name cell is blank, show nothing.
  • If the name cell has a name, add Dr. before it.

This is perfect for long lists. You do not need to drag the formula down. Google Sheets handles the column like a helpful robot.

Method 7: Excel Flash Fill

Excel also has a clever feature called Flash Fill. It guesses what you want.

Here is how to use it:

  1. Put names in column A.
  2. In B2, type the first result, like Dr. John Smith.
  3. Start typing the next one in B3.
  4. Excel may show a preview.
  5. Press Enter to accept it.

You can also use the shortcut Ctrl + E on Windows.

Flash Fill is fast. But formulas are safer if your data may change later.

How to Replace the Original Names

Formulas create new results in another column. They do not change the original names.

If you want to replace the original names, do this:

  1. Create the prefixed names in a new column.
  2. Select the new results.
  3. Copy them.
  4. Right-click the original name column.
  5. Choose Paste special.
  6. Select Values only.

This pastes the final text, not the formula.

Be careful here. Once you replace the old names, the plain names are gone unless you undo or have a backup.

Common Prefix Examples

Here are some ready-to-use formulas.

  • ="Mr. "&A2
  • ="Mrs. "&A2
  • ="Ms. "&A2
  • ="Dr. "&A2
  • ="Prof. "&A2
  • ="VIP "&A2
  • ="Guest "&A2

You can use almost anything as a prefix. Just place it inside quotation marks.

Quick Tips for Clean Results

  • Use quotes around typed text, like "Dr. ".
  • Add a space before the closing quote.
  • Use cell references if prefixes vary by person.
  • Use TEXTJOIN if blanks may appear.
  • Paste values when you want final text only.

Final Thought

Prefixing names in Excel or Google Sheets is simple once you know the pattern. Put the prefix in quotes. Add a space. Join it to the name with &, CONCAT, or TEXTJOIN. That is it.

Your spreadsheet can now turn plain names into polished names in seconds. It is tidy. It is fast. And yes, it feels a little bit like giving every name a fancy little bow tie.