Hey all,

How can I AUTOMATICALLY add a text string to a existing string when the existing string is not constant? I'm thinking maybe an IF function with a CONCATENATE function? I need all strings to equal this format - 0d 00h 00m. The challenge is when copied from other files it is not constant, ex.:

E4: 2h 39m
E6: 56m
E8: 12h 08m
E10: 5m

I need all of the above to read like this:

E4: 0d 02h 39m
E6: 0d 00h 56m
E8: 0d 12h 08m
E10: 0d 00h 05m

I need the formula to read the string in the cell(s) and add whatever string is necessary to meet the desired result of 0d 00h 00m (as described above). If the cell is already reading 0d 00h 00m then no action is required. I've tried other ideas and have had other posts with a different approach but none seem to work. I'm thinking this might be an easier problem to solve. After my text reads like above I use the RIGHT & LEFT functions to extract the digits so I have just the days, hours, minutes remaining so I can then add them to NOW() to know when our deadlines are due.

Thanks in advance for your help,

Keyrookie