I am copy-pasting data off the internet which comes into Excel with leading spaces. eg: " COMMUNICATIONS".
I cannot use =TRIM to remove the spaces as they are Char(160) 'non-breaking spaces' not the usual char(32) spaces.
I can't even use trim in VBA code to remove the spaces.
Any suggestions? I have attached a worksheet.