i have the following codes in excel
025.555_0010 (in cell A60) and i want a formula to change the 1st 6 numbers of the id so that it reads for example 010.560_0010 could you please assist with a formula for cell A60

Did you tryed using Find and Replace (Ctrl+H) Excel's function for this? Capturar.JPG

Frank .S

ASKER

these solutions dont work for hundreds of items i need to change, they only work for a single item, i need to copy and paste the formula, please adjust

the problem i have is that i need a formula to adjust not only the 1st 3 numbers, ie 025, which is ok if i use the formula below, but i also need to adjust the next 3 numbers of the id ie 555,in the same formula. so the id should read after the formula is applied 010.900_0020

025.555_0020
=SUBSTITUTE(A61,"025","010")

duderde

If you want to replace the numbers directly in column A you will have to use a macro.
How do you get the replacement numbers? Are they different for every line in the column or is it always 010.900? Where do you define that?
Please provide a longer excerpt from your worksheet, so that the problem becomes clearer.