I would like to remove the comma, but only one that is at the end of my string(there is a space after the comma, should be also removed)
How should I do that in vba?
str = "coco rico, " ' Why not...
I = InStrRev(str, ",") ' Here is the trick: locate the comma from right to left
str = Mid(str, 1, I - 1) ' Typical transfer...