M
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
get rid of them without going through each cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
One way, assuming source in A1 down
Put in B1: =SUBSTITUTE(A1,"""","")
Copy down
Put in B1: =SUBSTITUTE(A1,"""","")
Copy down
C
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
feature that will delete any character you choose..........
Vaya con Dios,
Chuck, CABGx3
M
mark
Very impressive add on thankyou..did the trick !
CLR said: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
C
CLR
You're welcome.........thanks for the feedback.
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
T
Teethless mama
Highlight your range then ctrl+H
Find what: ""
Replace: leave it blank
Click Replace All
Find what: ""
Replace: leave it blank
Click Replace All