I am sure that this is a simple one but it has stumped me.
Does anyone know how to get rid of apostrophes surrounding a number in a cell? I have got table data from the web but it appears with apostrophes – I'd like to be able to remove these and convert to double.
Many thanks
Best Answer