Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing commas from numbers etc. | Excel Worksheet Functions | |||
Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
removing commas from a string | Excel Programming | |||
Removing commas | Excel Worksheet Functions | |||
Removing commas | Excel Programming |