View Single Post
  #12   Report Post  
Ken Wright
 
Posts: n/a
Default Help...Need to modify data within a column in a .csv file

You're very welcome - glad it worked for you. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

wrote in message
oups.com...
Your formulas worked to perfection, Ken. The only nitpick was that I
had to change the picture of the date at the end of the 2nd formula to
"mm/dd/yy", very minor thing. Clever the way you had to handle the
double-quotes with their character representation. Many thanks, Ed