Please help me with altering text in excel

[mark]

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

 

[Max]

One way, assuming source in A1 down
Put in B1: =SUBSTITUTE(A1,"""","")
Copy down

 

[CLR]

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will delete any character you choose..........

Vaya con Dios,
Chuck, CABGx3

 

[mark]

Very impressive add on thankyou..did the trick !

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will delete any character you choose..........

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

You're welcome.........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3

 

[Teethless mama]

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