Highlight your range then ctrl+H
Find what: ""
Replace: leave it blank
Click Replace All



"mark" wrote:

I have imported text data and it is surrounded by double quotes "" How do I
get rid of them without going through each cell