| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to combine 2 cells' text 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. |
|
#2
|
|||
|
|||
|
=B1&" "&B2
-- Regards, Peo Sjoblom (No private emails please) wrote in message ups.com... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text to appear at top of cell | New Users to Excel | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
