In this article, we are going to learn how we can join the text by using formula and function in Microsoft Excel.
In Excel, we have built-in function that we use to join the text and cells. We have a formula to join the text or cells.
To join the several text strings with another text string, we use concatenate formula.
Using Concatenate Function
Let’s take an example and understand:-
We have name list data in range A1:C6. Column A contains First Name, Column B contains Middle name and Column C contains Last name. We need to join the Full name in a single cell.
To join the text with spaces, follow below mentioned steps:-
Using “&” in Formula
Now, follow below steps to join multiple text string with single text string:-
Formula Explanation:- We have selected cell A2 then “&” sign to add another string, then we have added space between inverted commas in order to provide space between strings.
Here’s the procedure we followed in this formula.
In these ways, we can join several text strings with one string in Microsoft Excel by using the formula & functions.
Conclusion: - In Excel, we have various options to do one thing. Therefore, various problems can be resolved by using ‘Options’ and Formulas.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.