| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing large amount of Data
Edit Replace
In the Find what field put - In the Replace with field put nothing Touch Replace All -- Gary's Student gsnu200701 "glnbnz" wrote: I would like to simply change a large number of records in a spreadsheet without having to change each one individually. Here is my example: Befo 21-101-38468-00-00 Change to: 21101384680000 How can I do this? There are over 14,000 records Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Condensing a large data dump | Excel Discussion (Misc queries) | |||
| Changing entire column data | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Hybrid Mode
