Replace Within A String...

[omnitech]

Can someone help me replace something with something else in a string. I know all about the Replace function, but to use that you need to know the exact characters your replacing, right? Well say I have a string that says "010115500." If your asking why I store numbers in a string it's because I need it to have those 0's in the beginning to have the exact number of places each time and this is the easiest way for me. But say I want to Replace the first 3 digits: "010" with "000", leaving the rest the same and returning "000115500." How would I do that, and also to have it replace those first 3 digits no matter what they are. If they are 999, it's still supposed to be replaced 000, if it's 123, same thing, and so on. Is there some type of thing I can use to have it just Replace those first few characters no matter what they are? I tried using those wildcard character things, but that didn't seem to work.

[MartinLiss]

Use the Mid$ or Right$ function to grab all but the first three characters of the number, then prepend the new value to the part you grabbed.

[omnitech]

Yeah I just figured that out. I feel so stupid right now...