replace data w/ new data

  • Thread starter Thread starter tawny
  • Start date Start date
T

tawny

I have a text file that I opened in excel and need to replace some of the
data with new data. I cannot use the find/replace all function because the
old data is not in a consistent list form. The data I need to replace is in
column F. But there is also other info in the same column that I don't want
to lose.

Old Data:
MAN GM 1.07305E+17 CP 1Z7812X90312160167~

New Data:
1Z67X81F0345554229~

It's very hard for me to explain...but I have hundreds of these that I need
to replace the invalid tracking numbers with the valid ones.

Thanks,
 
Excel is trying to "help" you. It is converting your ID numbers into another
numerical format. You can prevent this when you open the file. When you
open the file, tell the Import Wizard that the field is Text and not General
and the Wizard will not change the values.
 
Back
Top