I am trying to create a macro to remove a space at the end of my text/numbers. I have used
This works perfectly for everything except when I want it to find the space at the end of my characters.
Please Login or Register to view this content.
I've copied and pasted the "character" in between the quatation marks to find but it just brings up a question mark.
does anyone know what this character is or how to remove it?
I've attached a file with an example of what i have in A1
It's driving me crazy as it's the last part of my macro and it will make life easy for my staff.
Thank you in advance
Mod's note: Code tags added for you...this time