How to add prefix or suffix to range of cells in Microsoft Excel 2016 ?

This blog post will explain in how to add prefix or suffix to a range of cells in Microsoft Excel 2016 using the formula.

How to add prefix or suffix to range of cells in Microsoft Excel 2016 ?

There are times when you might want to prefix a text or suffix a text to a range of cells. One way of doing it is by doing it manually on each cell. It is definitely time consuming. Instead , you can use formula sin Microsoft Excel to do it quickly.

Assume that you have cells “B1 to B5” that contains the data which needs to be prefixed with the text “Senior” and displayed in the cells D3 to D5.

image

We can use the CONCATENATE function to prefix the text.

=CONCATENATE(“Senior  “,B3)

Once you enter the formula on pressed the enter key in the Cell D3 , it should display the text along with the prefix. Now , select the cell D1 and then drag the Autofill handle till B5 (the range of values where you want this formula to be applied).

You should immediately see the range of cells prefixed with the desired value.

image

Similarly , you can suffix the range of cells using the same steps as described in this blog post with a different formula. The formula for suffix would be

=CONCATENATE(B3,” Level 1″)

Where the Level 1 Text would be suffixed to the cells.

Leave a Reply