Cander,

Lets work with my example:

sNums = Var1 & "," & Var2 & "," & Var3 & "," & Var4 & "," & Var5


Lets say that Var3 and Var5 are empty then the output will be:

"John, Larry, , Bob, "

I want it to output as :

"John, Larry, Bob"

So you suggest using this as the line of code?

snums = Replace(sNums, ",,",",")