What is the formula to show (not add) the values of different cells in one cell?

[Madmaxneo]

For example: C4=5,C5=18, and C6=7.
I want A1 to show 4,5,18,7 (the values of cells C4 to C6).

I believe I have done this before, about 10+ years ago.

Bruce

[shg]

=c4 & " " & c5 & " " & c6

[pareshj]

Hi,

Use can simply use CONCATENATE function. Check the below formula :

=CONCATENATE(C4,",",C5,",",C6)


Regards,
Paresh J

[cbatrody]

Hi,

Please use the following formula in A1

=CONCATENATE(C4,",",C5,",",C6)

[Madmaxneo]

Ahh that's what it was, CONCATENATE. Thanks guys!

I was in Dubai way back in the early 90's! I think I might have been to Mumbai also, not sure though.

Bruce