How to add both prefix and suffix at a time in Microsoft excel

How to add both prefix and suffix at a time in excel?
In this tutorial we are going to learn two ways to add both prefix and suffix in Microsoft excel. You can simplify this by saying how to add text, numbers, characters or symbol before and after a cell data, text, words etc. in excel.

What is Prefix?
A prefix is actually an affix which is generally placed before any word. By adding prefix to the beginning of any word you can change it into another word. For instance, if the prefix un- is added to the word lucky, it creates a new word unlucky.
In simple word prefix is a word, character or number placed right before another.

What is Suffix?
A suffix on the other hand is actually an affix which is placed after any word. By adding suffix to the end of any word you can change it into another word. In simple words suffix is a character, number or text placed right after another.

How to add Prefix in Microsoft Excel?
We covered two different ways of adding prefix in Microsoft Excel in two different video. Following are the links of those videos, please take a look.

How to add Suffix in Microsoft Excel?
Again I’ve covered two different ways of adding suffix in Microsoft Excel in two different video. Here goes the links of those videos, take a look.

How to add Prefix and Suffix at a time in Excel?
Let’s get right into it. We are going to solve this problem using formula.
=CONCATENATE

In the situation demonstrated in the video we use this formula in a way that we simply write the text we want to add as Prefix and Suffix right into it. Here it goes:
=CONCATENATE ("Food - ", B2, " - Vegetables")
Here the word FOOD is prefix and the word Vegetables is the Suffix. Cell B2 is the cell with whom we want to add Prefix & Suffix. Plain and simple.

In the second method I used the same formula in different ways.
=CONCATENATE (A2,B2,C2)
Here in A2 cell we have Prefix and Cell B2 Is the word with whom we want to add suffix and prefix. C2 is the cell where we have the suffix.

These were the simplest way of adding both prefix and suffix in Microsoft excel using formula.

-------------------------------------------------------------------------------------------------------------
Excel VBA Programming Course just started on this channel. Those who are willing to learn excel in a professional manner, you are welcome. Its 100% Free
-------------------------------------------------------------------------------------------------------------

Thanks for watching.

#prefix #suffix

-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[jindalrohit]

Thank you sir, you saved my hours & days :-)

[taherislam]

many many thanks.
I subscribed your channel.

[socc]

But how to add space between two selected cells. I mean i dont want FruitBroccoliVegetables but instead i want Fruit Broccoli Vegetables.