Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html

then use this formula

=SUBSTITUTE(TRIM(MCONCAT(IF(AE3:BG3<"",AE3:BG3,"" )&" "))," ",", ")

ctrl+shift+enter, not just enter



"Swiss" wrote:

I have a range of data in collumns that I wish to combine into one cell at
location E3 (with comas so it should look like 9,5,10b,4). The range is
AE3:BG3 but some cells are blank. The values in the cells are just numbers
but I dont want to add them, just display them. Any tips are appreciated.

the data looks like this:
AG AH AI AJ -
11 9 23 24 18 21 3 4 8 10b 15 16 20 17

11 18 21 4 10b 15 16 20 17