How to combine 2 cells' data into 1 cell?

  • Thread starter Thread starter athatisme4
  • Start date Start date
A

athatisme4

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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to combine 2 cells' text into 1 cell 1
Excel In Excel how can I block the contenent of a cell? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Altered pasting functionality 3
Help with Linq To Object 3
Line with length depending on the value of the cell 1
how to return "summary" of all non-blank cells plus their headers 10

Back
Top