Thread: Please help me with altering text in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Please help me with altering text in excel
One way, assuming source in A1 down
Put in B1: =SUBSTITUTE(A1,"""","")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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
Reply With QuoteReply With Quote