| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change second digit from 4 to 6
Hello from Steved
I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
Highlight cells,== Edit.. Replace, ==Find What: 4, Replace with : 6,
==Replace All. HTH "Steved" wrote: Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
Each number is in its own cell?
Put 200 in an empty cell Select that cell edit|copy select your range to adjust edit|Paste special|Add clean up that cell with 200 in it. or =a1+200 Steved wrote: Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
Hi Steved
Why not enter 200 in a empty cell Copy this cell Select the range and use EditPaste Special...Add -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
If you need a formula, simply do:
=replace(a1,2,1,"4") Replaces 1 character, starting from the 2nd character, with "4". This won't overwrite your old numbers, so the other suggestion appears to be better. A1 would be the cell you want replaced. Keep in mind that this will return a value in whatever cell you write the formula in - again, the other method shoold work better Ron de Bruin wrote: Hi Steved Why not enter 200 in a empty cell Copy this cell Select the range and use EditPaste Special...Add -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
.....ignore my crass reply ... bad day at the office. As other responses, add
200! "Toppers" wrote: Highlight cells,== Edit.. Replace, ==Find What: 4, Replace with : 6, ==Replace All. HTH "Steved" wrote: Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change second digit from 4 to 6
Hello from Steved
I thankyou all. "S Davis" wrote: If you need a formula, simply do: =replace(a1,2,1,"4") Replaces 1 character, starting from the 2nd character, with "4". This won't overwrite your old numbers, so the other suggestion appears to be better. A1 would be the cell you want replaced. Keep in mind that this will return a value in whatever cell you write the formula in - again, the other method shoold work better Ron de Bruin wrote: Hi Steved Why not enter 200 in a empty cell Copy this cell Select the range and use EditPaste Special...Add -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
| Can't change x-axis labels | Charts and Charting in Excel | |||
| Change value in cell | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Linear Mode
