How to combine 2 cells' data into 1 cell?

's Computer Specifications

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.

's Computer Specifications

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/
_______

(E-Mail Removed) 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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine two cells without losing data cell formats	johncaleb	Microsoft Excel Programming	2	6th May 2010 09:44 PM
combine data in two cells into a third cell	ordnance1	Microsoft Excel Worksheet Functions	3	25th Sep 2008 07:49 AM
How do i combine 2 cells contain date in one cell,	Bintaro645	Microsoft Excel Worksheet Functions	2	11th Aug 2008 02:16 PM
How to Combine Cells using Other Cell	pll	Microsoft Excel Worksheet Functions	3	30th Jul 2008 09:18 PM
How to combine 2 cells' data into 1 cell?	athatisme4@gmail.com	Microsoft Excel Discussion	3	12th Oct 2005 02:01 AM