joeu2004,

Thanks for the help. I forgot to check rngCol.Formula.
All I needed was: rngCol.Value = Mid(rngCol.Formula, 3)

You are right, I am opening the CSV then fix the data before saving it. I have to do it this way because there are fields with imbeded CR, LF and Tab characters in them that really mess it up when I import it.