Hi all,
I need to add a leading zero to any number, 1-9, contained within a string. If the number is greater than 9, the leading zero should not be added.
I've attached a sample xls here; the first column is the raw data and the second column is the output I expect. I've been able to extract the number included with a CSE of
I'm stuck though. I can't figure out how to easily (or not so easily) add the leading zero where needed then re-concatenate everything back into a neat little package. I am saddened to report that I have spent two solid hours on various hacks, none of which produce the correct output.
Any ideas on how to assist would be greatly appreciated.
Thanks,
jp
Bookmarks