| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 30741 | 2003-03-01 21:48:00 | find and replace number in excel | santae (2502) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 124894 | 2003-03-01 21:48:00 | have sheet called data1, has 1, and 2 numbers only. Want to replace number 2 with number 3. approx 3800 records. Can someone help. |
santae (2502) | ||
| 124895 | 2003-03-01 21:58:00 | Have you tried edit, replace? | wotz (335) | ||
| 124896 | 2003-03-02 02:57:00 | You use Ctrl F and put in the number to be replaced, then click on the Replace.. button. You can then fill in the 'Replace with' box then choose either to do it one at a time with 'Find Next' and 'Replace' or alternatively... you can choose 'Replace all' if you are very confident that there are no exceptions. :) |
Misty (368) | ||
| 1 | |||||