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

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!

MattAttachment 11318

Try

=A2&B2&C2

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

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

Perfect thanks, You can use spaces instead of commas if neccecary

If formatting is a concern, you could use TEXT() like this with the deliminaters explicity included between the TEXT()'s

Code:

---

=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

Code:

---

=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