How to add both prefix and suffix at a time in Microsoft excel
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 prefix to a single cell or range of cells in excel with VBA: https://youtu.be/c0QSBzud8MA
How to add prefix using functions In excel: https://youtu.be/IJm5n3p_RcY
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 suffix to a cell or data in excel using VBA: https://youtu.be/syg3SxqmXGQ
How to add suffix using function in Microsoft Excel: https://youtu.be/zzq4E_i2MpQ
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
Here is the playlist: http://bit.ly/excelvbacourse
————————————————————————————————————-
Thanks for watching.
#prefix #suffix
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Thankyou for this👍
But how to add space between two selected cells. I mean i dont want FruitBroccoliVegetables but instead i want Fruit Broccoli Vegetables.
Thanks man. Was so helpful
Thank you sir, you saved my hours & days 🙂
many many thanks.
I subscribed your channel.
It helped