Hi there,

I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
....meaning I should have 1601.......1620.

Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!

Thx.

If the values are numbers (vs text) try this:

Enter 300 in a blank cell
Copy that cell

Select the range of numbers
From the Excel main menu:
<edit<paste special
Check: Add
Click the [OK] button

That should add 300 to each cell, converting the 1300 series to the 1600
series.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Nanou" wrote:

Hi there,

I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
...meaning I should have 1601.......1620.

Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!

Thx.

=(16&RIGHT(A1,2))*1

Vaya con Dios,
Chuck, CABGx3


"Nanou" wrote:

Hi there,

I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
...meaning I should have 1601.......1620.

Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!

Thx.

Hi,
Select 1301 to 1320 and use Find / Replace function to find 13 and repalce
with 16. Replace all. Only 1313 will become 1616 instead of 1613. Change that
manually.

"Nanou" wrote:

Hi there,

I am trying to replace multiple data in excel. Let's say I have couple of
cells with value 1301 .....1320, I need to replace only the first 2 digits
...meaning I should have 1601.......1620.

Tried multiple ways but did not work.......any help will be greatly
appreciated!!!!

Thx.