How to Add Prefix and Suffix to Entire Column in Excel

We earn commission when you buy through affiliate links.

This does not influence our reviews or recommendations.Learn more.

it’s possible for you to swiftly apply prefixes and suffixes to columns using advanced Excel functions.

Well go through three different ways to add suffixes and prefixes to an Excel spreadsheet.

Lets look at an instance of using & in Excel to add a Prefix.

This step will addPrefixMr.to that particular cell.

It is pretty simple to understand and implement.

You have successfully added a prefix to all cells in a few seconds.

The PrefixMr.can be replaced with any prefix as per the requirement.

As shown in the below Excel, column B contains the names of the vegetables.

The task is to add the Suffix vegetables to all cells.

Place the cursor at cell C5, pop in=B5 & - vegetables,and press enter.

It will addSuffixvegetablesto the C5 cell.

Drag the Cell corner of C5 as shown below to apply suffixes to all cells.

This adds suffixes to all cells.

You have successfully appended Suffixes to every cell in just a few seconds.

Like prefixes, any suffix can be used instead of vegetables.

The function concatenation combines two or more text strings to create a single string.

This step will add the prefix Mrs. to that particular cell, as shown below.

You have successfully appended prefixes to every cell in just a few seconds.

This section will look at how to do it in the same cell.

Right-clicking brings up the properties box, as seen in picture 1.

Lets rapidly append the suffixEnggto every cell.

This aids you in formatting the Excel file quickly.

Further Reading#