Hi all
I'm using Excel 2003, Windows XP
I'm trying to get rid of all trailing commas in a text string, for example:
"Steve Smith,,,,,,,,,,,"
"Sarah Golding,,,,,,"
The number of trailing commas varies in a list of 500 names - I've tried a few formulas including these two...