=MultiCat removing commas from a string

I D/L this script for an excel concatenate problem I had, and it works exactly the way it says it should. It's function is to concatenate a list of cells (the =concatenate in Excel cannot do this for a range, only for identified cell refs, I have a column of over 300)

My problem is that many cells in my lists are empty and my output from =MULTICAT has strings of commas (the delimiters I chose) where the empty cells are, so a result will look like this :

,,,,,,,,,word1,,,,word2,,,word3,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,word4,,,,,,,


I want it to read:

word1,word2,word3,word4


etc....
the format for MULTICAT is =MULTICAT(A1:a500,",")

Can someone suggest a way to either make multicat more appropriate for me, or a simple formula that will chop out the commas, except between words.

many thanks even if u just took the time to read and can't help.
Heres the MULTICAT code:
'*****************************************

Please Login or Register  to view this content.

You need to select Go Advanced and click on the hash icon (#)

Please Login or Register  to view this content.

Regards