We help IT Professionals succeed at work.

excel formula - renumbering ids - 6 number change

Frank .S
Frank .S asked
on
186 Views
Last Modified: 2012-06-27
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
Comment
Watch Question

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

Rob HensonFinance Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

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

Author

Commented:
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
Frank .SBuilding Estimator

Author

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

Commented:
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.
Frank .SBuilding Estimator

Author

Commented:
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.