Table of Contents
Adding a prefix to cells in Excel is a simple process that can be done in a few easy steps. First, select the cells that you want to add the prefix to. Then, right-click on the selected cells and choose the “Format Cells” option. In the Format Cells window, go to the “Number” tab and select the “Custom” category. In the “Type” field, enter the prefix that you want to add, followed by the format code for the cell values (e.g. # for numbers, @ for text). Click “OK” to apply the changes and the selected cells will now have the prefix added to them. This method can be used to add a prefix to multiple cells at once, making it a quick and efficient way to modify your data in Excel.
Add Prefix to Cells in Excel (With Examples)
You can use the following basic syntax to add a prefix to a cell in Excel:
="Mr. "&A2
This particular example will add the prefix “Mr. ” to the existing text in cell A2.
For example, if cell A2 contains Andy Miller then this formula will return Mr. Andy Miller.
The following example shows how to use this formula in practice.
Example: How to Add Prefix to Cells in Excel
Suppose we have the following column of names in Excel:
Suppose we would like to add the prefix “Mr. ” in front of each name.
We can type the following formula into cell B2 to do so:
="Mr. "&A2
We can then click and drag this formula down to each remaining cell in column B:
Column B now contains each name from column A with the prefix “Mr. ” added before it.
Note that you can use this exact same syntax to add whatever prefix you’d like.
For example, you could instead add “Dr. ” in front of each name by using the following formula:
="Dr. "&A2
Or you could use the following formula to add the prefix “Name: ” in front of each name:
="Name: "&A2
The following screenshot shows how to use this formula in practice:
Feel free to use this general formula to add any prefix you’d like to each cell in a specific range.
Note: The & symbol in Excel offers a quick and easy way to concatenate values together.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: