In Excel merge the cells by using the Concatenate function. To combine excel text formula from different cells or to merge data in excel “CONCATENATE” formula is the best way.
CONCATENATE function allows to join the cell text from multiple cells into a single cell.
Example 1: We have data in range A1:B11, in which the 1st text string is in column A and the 2ndin column B. To combine both the text in excel strings into one cell follow the below given steps –
To combine the text from different cells you can use another formula too:-
Here, we have reviewed the joining of 2 strings. But we can also join multiple text strings into one string, provided the total text in the cell does not exceed 255 characters.
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.