PC Review


Reply
Thread Tools Rate Thread

How to combine 2 cells' data into 1 cell?

 
 
athatisme4@gmail.com
Guest
Posts: n/a
 
      12th Oct 2005
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.

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      12th Oct 2005
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.
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:23 PM.