combining text with comma if any of the cells data is present in 3 columns

Hi,

I have used below function in Column D

=CONCATENATE(A2&","&B2&","&C2)

where I joined 3 columns into one separated by comma.But the problem is that when either of the row does not contain anything,it does show single comma and double comma either at the end or in between.How to get those removed those extra comma.

Pls do not use VBA.

With Best Rgds

suresh

Try

=SUBSTITUTE(TRIM(A2&" "&B2&" "&C2)," ",",")