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
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
=c4 & " " & c5 & " " & c6
Entia non sunt multiplicanda sine necessitate
Hi,
Use can simply use CONCATENATE function. Check the below formula :
=CONCATENATE(C4,",",C5,",",C6)
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Hi,
Please use the following formula in A1
=CONCATENATE(C4,",",C5,",",C6)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks