Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup for data contained in a cell	Garbunkel	Excel Worksheet Functions	5	September 14th 05 06:47 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
how do i seprate multi data cell into 2 or more cells	vinlouis	New Users to Excel	2	February 22nd 05 05:26 PM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

All times are GMT +1. The time now is 02:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us