Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global find and replace in Excel 2007
I want to replace the last 2 digits of a series of cells that contain an 8
digit number and other text. The number is 18081800 and I want to make the last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole number with the wildcards as well as 01. What am I doing wrong and can you give me an example of the right wat to do this. Here is what I did: Find what: 180*00 Replace with: 180*01 It replaces 18081800 with 180*01. Why? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Global find and replace in Excel 2007
Are you trying to add 1 to the existing value in that cell--or are you trying to
replace the last two digits of any number with 01? If it's the first, you can: Select an empty cell type 1 into that cell Edit|copy (or its equivalent in xl2007) Select the range to adjust Edit|paste special|values and add (or its equivalent in xl2007) And then clean up that cell with the 1 in it. If it's the second, you could use a formula... Woodman wrote: I want to replace the last 2 digits of a series of cells that contain an 8 digit number and other text. The number is 18081800 and I want to make the last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole number with the wildcards as well as 01. What am I doing wrong and can you give me an example of the right wat to do this. Here is what I did: Find what: 180*00 Replace with: 180*01 It replaces 18081800 with 180*01. Why? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace in Excel 2007 | Excel Discussion (Misc queries) | |||
how do i find edit, replace in excel 2007 | Excel Discussion (Misc queries) | |||
how do I do a global replace in all sheets in a workbook? | Excel Worksheet Functions | |||
how to do global replace in hyperlinks for entire excel document? | Excel Discussion (Misc queries) | |||
GLOBAL search and replace | New Users to Excel |