How to combine different cells data in one cell?

Learner7 · #1 07-28-2010, 05:08 AM

Hi,

How can I combine the data (text & numbers) of various cells Say: Cell C1, C2, C3, C4, C5 into Cell C6?

For example:

C1= Quotation
C2= against
C3= No. 54125
C4= is not valid
C5= $50 to be paid.

C6= Quotation against No. 54125 is not valid $50 to be paid.

Thanks.

ConneXionLost · #2 07-28-2010, 12:07 PM

Hi,

Code:

=C1 &" "& C2 &" "& C3 &" "& C4 &" "& C5

or,

Code:

=CONCATENATE(C1," ",C2," ",C3," ",C4," ",C5)

Cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying cell data in another spreadsheet	Colonel Biggs	Excel	0	07-01-2010 07:37 PM
Copying data from one cell to another automatically	mrphilk	Excel	4	06-10-2010 11:52 PM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM