Hello everyone,
Is there anyway to remove a comma, but only in the case where nothing would follow it. I have some data that can come in two varieties. The first:
Data, data
Is just fine the way it is.
The second type:
Data,
Is okay, but would look much neater if I could remove the superflous comma. The data length is variable and I am doing this in a much larger VBA code that will analyze quite a few cells on a worksheet.
Is this possible?
Thanks in advance.
Is there anyway to remove a comma, but only in the case where nothing would follow it. I have some data that can come in two varieties. The first:
Data, data
Is just fine the way it is.
The second type:
Data,
Is okay, but would look much neater if I could remove the superflous comma. The data length is variable and I am doing this in a much larger VBA code that will analyze quite a few cells on a worksheet.
Is this possible?
Thanks in advance.