I have a series of 8 digit numbers that I want to add 2 zero's to the middle of the numbers. For instance, I want 30251111 to be 3025001111. Without manually retyping every number (I have over 1,500 to modify), is it possible to do this with a formula? Any help would be appreciated!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!