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

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

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

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

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

.....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

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