Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Combine texts from multiple cells into one cell in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 268

PostPosted: Sun Dec 18, 2016 9:10 pm    Post subject: Combine texts from multiple cells into one cell in Excel Reply with quote

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

See the following example:





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 (" ").






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.






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





Have fun Smile




*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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group