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.