Forum Discussion
Removing unwanted punctuation from excel
Have brought across some data from my website and need to up load it to another service but it has all come in with postcodes within speechmarks. eg "AB1 3ED" i need to remove the speechmarks...
jazshouse Use Find & Replace. Select the column with the postcodes, press Ctrl-H and replace the quotation marks with nothing.