Microsoft Office Forums - View Single Post - [Solved] How to combine different cells data in one cell?

Thread: [Solved] How to combine different cells data in one cell?

View Single Post

Old

07-28-2010, 12:07 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Hi,

Code:

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

or,

Code:

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

Cheers,

Reply With Quote