• No products in the cart.

Joining two or more cells in Excel 2010

How to Joining two or more cells in Excel 2010

Excel uses an ampersand (&) as its concatenation operator. Concatenation is simply a fancy term
that describes what happens when you join the contents of two or more cells. For example, if cell
A1 contains the text Tokyo and cell A2 contains the text Japan, the following formula then
returns TokyoJapan:


Notice that the two strings are joined together without an intervening space. To add a space
between the two entries (to get Tokyo Japan), use a formula like this one:

[quote]=A1&” “&A2[/quote]

Or, even better, use a comma and a space to produce Tokyo, Japan:

[quote]=A1&”, “&A2[/quote]


November 3, 2015

0 responses on "Joining two or more cells in Excel 2010"

Leave a Message

All right reserved VeerTutorial