View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ziggynorton ziggynorton is offline
external usenet poster
 
Posts: 1
Default removing commas in csv


Hi, my first post!
I have a workbook which I need to change into a comma delimited file s
as to import it into Access (it won't import with the normal xls fil
but it's ALMOST right if I use csv). It works fine until I try t
import memo fields containing a comma, wherein it uses the comma t
create a new cell. What I want to do is to have all the commas remove
from the memo fields. I did find a piece of code which should do thi
but have no idea how to implement it. Any suggestions gratefull
received. Thanks. Ziggy

--
ziggynorto
-----------------------------------------------------------------------
ziggynorton's Profile: http://www.excelforum.com/member.php...fo&userid=3521
View this thread: http://www.excelforum.com/showthread.php?threadid=55175