Sep 29 2021 07:53 AM
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 on over 1000 lines!
any got an easy fix?
(have seen how to remove special characters but it also removes the numbers or letters)
thanks
Paul
Sep 29 2021 08:26 AM
@jazshouse Use Find & Replace. Select the column with the postcodes, press Ctrl-H and replace the quotation marks with nothing.