i am trying to record a macro that will help speed up some data problems I have. I'd like to take a series of data that is formatted like this: 00:00:41:02 and make it 00:41:02:00. i successfully created a macro that will delete the first 00: and then append a :00 onto the end of that type of string. however, pretending 00:00:41:02 is the cell i created the macro on, once i run the macro, it overwrites the number that exists in the following cells. so, as an example 00:00:50:10 would become 00:00:41:02 instead of 00:50:10:00. obviously, my macro isn't very useful in it's current state.
is there some sort of wildcard character that can tell a macro to maintain the numbers that exist in subsequent cells? i tried what i thought might be obvious things, but to no avail.
thanks in advance for any advice.