How to combine different cells data in one cell?

		Microsoft Office Forums > Microsoft Excel > Excel
How to combine different cells data in one cell?

07-28-2010, 12:07 PM

ConneXionLost ConneXionLost is offline

Windows XP How to combine different cells data in one cell?

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:33 AM.