Change second digit from 4 to 6

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Highlight cells,==> Edit.. Replace, ==>Find What: 4, Replace with : 6,
==>Replace All.

HTH
 
Highlight cells,==> Edit.. Replace, ==>Find What: 4, Replace with : 6,
==>Replace All.

HTH
 
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
 
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
 
Hi Steved

Why not enter 200 in a empty cell
Copy this cell

Select the range and use Edit>Paste Special...Add
 
Hi Steved

Why not enter 200 in a empty cell
Copy this cell

Select the range and use Edit>Paste Special...Add
 
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
 
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
 
.....ignore my crass reply ... bad day at the office. As other responses, add
200!
 
.....ignore my crass reply ... bad day at the office. As other responses, add
200!
 
Hello from Steved

I thankyou all.

S Davis said:
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
Click to expand...
 
Hello from Steved

I thankyou all.

S Davis said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

106% to this please 6% 7
Display Zero only in Selected Cells using a formula 8
change first 2 digit ignore the other 2. 6
In column B:B and D:D I've a Formula 6
3.10 PM to 24 hour time please ( 1510 ) 5
Using VBA for Inputting a "-" 5
sumif? countif? 3
Formula to sum the digits 14

Back
Top