Combine texts from multiple cells into one cell in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 294
Joined: Tue Sep 25, 2007 12:41 pm

Combine texts from multiple cells into one cell in Excel

Post by Admin » Sun Dec 18, 2016 9:10 pm

In Excel You can easily combine texts from two or more cells into one cell using the ampersand (&) operator.

See the following example:


Image


In cell C2 enter =A2 & " " & B2

For the remaining cells simply copy the formula down the column. That's it.



In the following example you combine texts from three cells into once cell. That means for multiple cells just type &" " & after each cell you select. Give space between two quotation marks (" ").


Image



As you now know the ampersand (&) operator is used to join the text strings. If you would only use it without the quotation marks (" ") in between it would combine the text string without any space, like the example below.


Image



If you would use a comma followed by a space between the quotation marks &”, “& , you wold have the following results.


Image


Have fun :-)




*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com

LindaRDale
Posts: 1
Joined: Fri Oct 25, 2019 6:24 am

Re: Combine texts from multiple cells into one cell in Excel

Post by LindaRDale » Fri Oct 25, 2019 6:33 am

Of, course Excel is great platform to store your file securely. We can also easily combine texts from two or more cells into one cell using the ampersand operator. I have a webpage https://www.resumesservicesreview.com/resumeprofessionalwriters-com-review/ and i also have many important pages or file I always want to do this on the Excel ways it is easy way to secure your data which looks so attractive.

Post Reply