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: 291
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

BarryTax
Posts: 8
Joined: Thu Jun 27, 2019 4:53 pm
Location: United Kingdom
Contact:

Combine texts from multiple cells into one cell in Excel

Post by BarryTax » Wed Jul 10, 2019 8:54 am

ouch.

I cant find a variable for the search string that will get you all, or even each full text. I think the backup file has too many symbols that mess with the search.

I might also make a copy of the file and start butchering all other texts out of that doc. Hopefully ending up with one full backup and one of just nuttiness.

Post Reply