I've attempted this all day today and have been unable to get anywhere, except through a long, tedius macro that does one excel box at a time. Here's the situation and what I need to do:
I have data that gets exported into a table format, which I copy and paste into Excel. The data can ONLY be exported in the following example format:
:06:08
:07:08
1:06:35
:06:30
Each of these are representing minutes and seconds related to my project. Now, in Excel, the formulas don't work properly unless a '0' is entered before the first semi-colon, like this:
0:06:08
0:07:08
1:06:35
0:06:30
I need to have it highlight and copy the table (yeah, easy) and then have it add a 0 in front of any semi colon that does *not* have a digit preceding it.
Eg: Add 0 in front of :06:08 but not in front of 1:06:35
I can't simply replace every case of ':' with '0:' because that would make it look like: 0:060:06, and it ruins a lot of my formulas. And, I can't figure out how to get it to recognize that 0:, 1:, 2:, 3:, 4:, 5:, 6:, 7:, 8:, and 9: are different than just : with nothing in preceding it.
Any possible solutions or direction would be much appreciated!
How to distinguish between the same characters?
in Macro Express 3.x
Posted
I've attempted this all day today and have been unable to get anywhere, except through a long, tedius macro that does one excel box at a time. Here's the situation and what I need to do:
I have data that gets exported into a table format, which I copy and paste into Excel. The data can ONLY be exported in the following example format:
:06:08
:07:08
1:06:35
:06:30
Each of these are representing minutes and seconds related to my project. Now, in Excel, the formulas don't work properly unless a '0' is entered before the first semi-colon, like this:
0:06:08
0:07:08
1:06:35
0:06:30
I need to have it highlight and copy the table (yeah, easy) and then have it add a 0 in front of any semi colon that does *not* have a digit preceding it.
Eg: Add 0 in front of :06:08 but not in front of 1:06:35
I can't simply replace every case of ':' with '0:' because that would make it look like: 0:060:06, and it ruins a lot of my formulas. And, I can't figure out how to get it to recognize that 0:, 1:, 2:, 3:, 4:, 5:, 6:, 7:, 8:, and 9: are different than just : with nothing in preceding it.
Any possible solutions or direction would be much appreciated!