maaaan this is annoying! as usual I am hoping that an expert can give me a quick answer as opposed to my useless fiddling!
I have a sheet of around 3000 names in column a and am de-duping them, the only problem is that some of the cells have spaces after the surname, therefore the =a3=a2 to get a true or false doesn't work.
I have tried various Trim / Len features but seem to be missing the point!
example:
a2 = jon smith
a3 = jon smith_ (where _ indicates a space after the name)
Is there code that can remove any blank spaces from the right of the text string?
As ever really greatful for help!
I have a sheet of around 3000 names in column a and am de-duping them, the only problem is that some of the cells have spaces after the surname, therefore the =a3=a2 to get a true or false doesn't work.
I have tried various Trim / Len features but seem to be missing the point!
example:
a2 = jon smith
a3 = jon smith_ (where _ indicates a space after the name)
Is there code that can remove any blank spaces from the right of the text string?
As ever really greatful for help!