Frank .S

asked on

# excel formula - renumbering ids - 6 number change

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

OS im using is windows 7

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

OS im using is windows 7

="010.560"&MID(A60,7,100)

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

Capturar.JPG

Capturar.JPG

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

ASKER

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")

025.555_0020

=SUBSTITUTE(A61,"025","010

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.

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.

ASKER

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.