Hi
I'm an Excel 2010 user and I regularly receive worksheet data that contains leading, trailing & non-breaking spaces.
I remove them by using the worksheet functions =TRIM(CLEAN(SUBSTITUTE(B1,CHAR(160)," ")))
The field that normally contains the troublesome spaces doesn't always appear in column B and because I get them regulary I was hoping someone could enlighten as to how I could create this as a macro?
Many thanks in advance.
Kenneth
Bookmarks