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.
"The easiest way to do this is in a new column enter the formula =a1&"".gif""
Copy the formula down to the end of the range.
When finished copy and paste special_values
You now have the value from column A and the suffix.gif in text
I am trying to see if there is a way to join two different colums of text into on colum? I am trying to populate my web store with these products from my distributor. One colum has the product name such a ARG12 and then the second colum has ""noimage.gif"" but I changed ""noimage.gif"" to just "".gif"" now if i could only find a way to merge or joing these two colums, then the image names would all be easily imported (there over 2000) and having to manually type a "".gif"" after each one would take forever...There must be a way to merge two colums of text? or a way to easily do this so that i end up with ARG12.gif in one colum?
AIM Y! MSN loopwisechat