Removing unwanted punctuation from excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2795517%22%20slang%3D%22en-US%22%3ERemoving%20unwanted%20punctuation%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2795517%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20brought%20across%20some%20data%20from%20my%20website%20and%20need%20to%20up%20load%20it%20to%20another%20service%20but%20it%20has%20all%20come%20in%20with%20postcodes%20within%20speechmarks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeg%20%22AB1%203ED%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20to%20remove%20the%20speechmarks%20on%20over%201000%20lines!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20got%20an%20easy%20fix%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(have%20seen%20how%20to%20remove%20special%20characters%20but%20it%20also%20removes%20the%20numbers%20or%20letters)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2795517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2795640%22%20slang%3D%22en-US%22%3ERe%3A%20Removing%20unwanted%20punctuation%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2795640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1170191%22%20target%3D%22_blank%22%3E%40jazshouse%3C%2FA%3E%26nbsp%3BUse%20Find%20%26amp%3B%20Replace.%20Select%20the%20column%20with%20the%20postcodes%2C%20press%20Ctrl-H%20and%20replace%20the%20quotation%20marks%20with%20nothing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

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

1 Reply

@jazshouse Use Find & Replace. Select the column with the postcodes, press Ctrl-H and replace the quotation marks with nothing.