Excel is by far one of the most comprehensive and versatile spreadsheet management programs. It has everything you want for your songs and more.

In this article, we will see how to add prefixes and suffixes to cell data in Excel.

Also read : How to convert seconds to minutes in Excel?

We can use two functions to add a prefix to some or all cells in a given column.

  • Use of the & operator.
  • Use the CONTEXT function.

Use and operation

The basic formula for adding a prefix with the & operator is as follows

=” “&

As you might guess, this is preceded by a prefix, followed by the operator and the cell number of the first cell or range of cells.

In the following example, we add +91 to the number line. Therefore, the team.

=+91 &C5

Insert this formula in an appropriate place in the cell. We’re calling the D5. Once you have entered the formula, you will see the value with the suffix. Now, while holding down the mouse button, drag from the bottom of the cell to the right to the last cell you want to add the prefix to, and Excel adds the prefix value to all cells.

Also read : How do I check my spelling in Excel?

Using the CONTENT function

The CONTEXTCENT function allows you to add prefixes to the cell data. The basic syntax is as follows.


Using the same example as above, the command in this case would be

=CHAIN(+91 .C5)

Insert the formula as before in D5 and you are done.

Also read : How can I remove duplicates in Excel?

Adding suffixes in Excel is as easy as adding prefixes. Again, there are two ways to do this.

  • Use of the & operator.
  • Use the CONTEXT function.

Use and operation

The basic formula for adding suffixes is as follows.


As you can see, this is essentially the reverse of what we did when we added prefixes with the & operator.

For the same example, the suffix formula would now look like this.


Paste this formula into a cell in a convenient location and drag it to add suffixes to any number of cells.

Also read : How do you write macros in Windows 10?

Using the CONTENT function

The basic formula is as follows.


Again, this is almost the opposite of what we did when we added the prefix with the CONTENT function.

The formula for adding the suffix in our case is as follows.


Also read : How to lock cells in Excel?

The one who writes/cuts/films/owns all the technology, and when he’s not around, switches to virtual machine races. You can contact Yadullah at [email protected], or follow him on Instagram or Twitter.

frequently asked questions

How do I add a prefix in Excel?

The questions… Add – normally…

How to enter a suffix in Excel

Office 2018 plug-ins Blog/05/16

How to add text to the beginning and end of a cell in Excel

I.D. 670-excel-a…

how to add prefix and suffix in word,excel add text to beginning of cell,adding suffix to words in excel,how to add prefix 0 in excel,how to write suffix in excel,how to remove prefix in excel,Feedback,Privacy settings,How Search works,how to add suffix in excel without formula,how to add prefix in excel without formula

You May Also Like

[Troubleshooting Guide]- 10 Ways To Fix Samsung Galaxy S10/S10+ Stuck On Samsung Logo

Is your Samsung Galaxy S10 blocking on the Samsung logo or a…

BenQ Zowie XL2546K Gaming Monitor Review

The BenQ Zowie XL2546 is definitely one of the most used monitors…

Introduction to Canonical Correlation Analysis (CCA) in R

Canonical Correlation Analysis or CCA is a technique for dimensional reduction, such…

How to test code built to save/restore Lifecycle of an Activity? –

Development issue/problem: How can I test all of the following methods? I…