Fixing Error 2029 (#NAME?)
Here is my problem, I am importing a CSV file that somewhere along the line got messed up. An alpha field managed to get a leading hyphen (ex: "-John Q Public"). When it gets imported, excel thinks it is a numeric value add an equals sign in front. Now the cell is an error (#NAME?). How can I programmatically fix the cell by removing the "=-"? I can identify it using IsError(rngCel.value), but I can not seem to modify the contents. Any suggestions?
|