How to Add a Word to the Beginning and Last of a Cell in Excel

 

How to Add a Word to the Beginning and Last of a Cell in Excel

In whichever cell  you want to add any text to the beginning of the text written, then you have to type a small formula, suppose you want to add the text "Mr" to the beginning of  "Ali" written in the A1 cell, then you have to type 

• = "Mr" & A1

Here you should also keep in mind that you have to give a space in front of whatever word you are adding like "Mr". You do not have to type  "Mr".

If a name is written in A1 and the father's name is written in A2 and you  want to combine both the cells  like A1 and A2 then you have to type 

• ="Mr"&B2 & "Son of Mr" &C2

So in this way you can combine the text written in two different columns.