View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeffrey Jeffrey is offline
external usenet poster
 
Posts: 25
Default Add a character in .cd file

I have a comma delimited file that opens up in Excel.
I need to add a quote character in the beginning of one cell.
Sample of what it looks like now: (all info is one cell such as A1)

this is in Cell A1
company name,"address","","city","state","zip"
this is in Cell A2
company name,"address","","city","state","zip"

I need it to look like this
Cell A1
"company name","address","","city","state","zip"
Cell A2
"company name","address","","city","state","zip"

Please note that the file has 2500 lines.