Removing extra characters

[Cheryl]

I have an imported table with lots of info in inverted commas such as "my name" "business type" etc. Is there a way to remove all the inverted commas? There are thousands of records so doing them manually is not an option. Thanks in advance

 

[khawar]

You can use the replace function to update data
Like

Replace("My Name",'"','""')

 

[Galaxiom]

Replace("My Name",'"','""')

That would replace one double quote with two.

You need:

Replace([fieldname],'"',"")