This Formula of Excel will remove all your fatigue.Work Smarter Not Harder

         This Formula of Excel will remove all your fatigue.Work Smarter Not Harder

Work Smart Not Hard - This is an example of this vlog in Excel, there are many big Formula, but the work that this small Formula can do is no one else, in this vlog we have told that Excel Cell has already How to add prefix or suffix to the beginning and end of type text or how to add any other text or how to combine two cells in Excel.

                           Add Specific Text to The Beginning/End of All Cells in Excel

Whichever cell you want to add text to at the beginning of the text, you have to type a small formula. Suppose you want to add "Sri" text to the beginning of "Ramkumar" written in cell A1, then you have to type

              ="Sri" & 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 don't have to type "Mr."

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

          ="Sri "&B2 & "Pun Sri " &C2

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

Tag - combine multiple columns in excel into one column, excel combine columns into one list, excel combine multiple columns into one long column, combine text from two or more cells into one cell, excel combine multiple cells into one separated by comma, how to merge cells in excel, merge data in excel, excel combine first and last name in one cell