PDA

View Full Version : Is it possible to display information from 3 cells side by side in a single cell?



mattwork
02-21-2014, 06:05 AM
Hi all,

I want to combine the information displayed in three seperate cells side by side in a single cell so that they are compatible for the software that powers a display board.

I've attached a photo of what I want done. I have simply typed the information into the combined cell but I want to use a formula so that it automatically updates.

I'm very new to this so please explain in as much detail as possible!

Thanks in advance!

Matt11318

Bob Phillips
02-21-2014, 07:09 AM
Try

=A2&B2&C2

If you need to delimit them, with say a comma, use

=A2&","&B2&","&C2

mattwork
02-21-2014, 08:08 AM
Perfect thanks, You can use spaces instead of commas if neccecary

Paul_Hossler
02-21-2014, 08:55 AM
If formatting is a concern, you could use TEXT() like this with the deliminaters explicity included between the TEXT()'s



=TEXT(A1,"#,##0.000_);(#,##0.000);0.000")&" "&TEXT(A2,"#,##0.000_);(#,##0.000);0.000")&" "&TEXT(A3,"#,##0.000_);(#,##0.000);0.000")



or as part of the format string



=TEXT(A1,"#,##0.000_); (#,##0.000); 0.000")&TEXT(B1," #,##0.000_);( #,##0.000); 0.000")&TEXT(C1," #,##0.000_); ( #,##0.000); 0.000")


Paul