How to combine 2 cells' data into 1 cell?
 

Hi all,

Assume Cell B1 is "ClassA"
Assume Cell B2 is "MayMay"

I would like to make D2 as "ClassA MayMay"


How can i do that?
I have tried to write as =B1,B2 it seems not workable~

Thanks.

Use '&' to build a string of characters:

=B1&" "&B2

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


wrote:

Hi all,

Assume Cell B1 is "ClassA"
Assume Cell B2 is "MayMay"

I would like to make D2 as "ClassA MayMay"


How can i do that?
I have tried to write as =B1,B2 it seems not workable~

Thanks.