Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
replace data w/ new data
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, -- Tawny Galvin VAS Entertainment |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
replace data w/ new data
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. -- Gary''s Student - gsnu200771 "tawny" wrote: 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, -- Tawny Galvin VAS Entertainment |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace static data by dynamic data without loosing all the formul | Excel Worksheet Functions | |||
How can I replace data in excel ?...Data positionsis a bit complic | New Users to Excel | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
How do you replace old data with new data without creating a new . | Excel Discussion (Misc queries) | |||
How do you replace old data with new data without creating a new . | Excel Discussion (Misc queries) |