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,

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 04:15 AM.