| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Replacing numbers
I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112,
209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Replacing numbers
select the dataedit replace209 210
Just make SURE that 209 doesn't exist anywhere else -- Don Guillett Microsoft MVP Excel SalesAid Software "Randy B." wrote in message ... I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112, 209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Replacing numbers
Hi,
Highlight the column where you have the numbers, hit Ctrl H, find what enter 209, replace with enter 210, replace all "Randy B." wrote: I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112, 209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Replacing numbers
Worked.
Thank you very much. I was trying to use * to place hold for the last 3 numbers and it didn't work. Thanks again. Randy "Don Guillett" wrote: select the dataedit replace209 210 Just make SURE that 209 doesn't exist anywhere else -- Don Guillett Microsoft MVP Excel SalesAid Software "Randy B." wrote in message ... I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112, 209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Replacing numbers
Worked.
Thank you very much. I was trying to use * to place hold for the last 3 numbers and it didn't work. Thanks again. Randy "Eduardo" wrote: Hi, Highlight the column where you have the numbers, hit Ctrl H, find what enter 209, replace with enter 210, replace all "Randy B." wrote: I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112, 209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Replacing numbers
Thank you for the feedback, if you click in the yes buttom to the question if
this was helpful will help others to get the answer , thank you "Randy B." wrote: Worked. Thank you very much. I was trying to use * to place hold for the last 3 numbers and it didn't work. Thanks again. Randy "Eduardo" wrote: Hi, Highlight the column where you have the numbers, hit Ctrl H, find what enter 209, replace with enter 210, replace all "Randy B." wrote: I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112, 209113). I would like to perform a bulk replace for just the first 3 numbers. Turn 209*** into 210***. Any suggestions? Thanks, Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replacing a range of numbers | Excel Worksheet Functions | |||
| Replacing a Range of Numbers | Excel Worksheet Functions | |||
| replacing numbers in a cell | Excel Worksheet Functions | |||
| Replacing specific numbers | Excel Discussion (Misc queries) | |||
| using treater than and replacing numbers | Excel Worksheet Functions | |||
Linear Mode
