Quote:
Originally Posted by Kevy Baby
I wonder if the time to create the above formula is less than just doing 12 search-and-replaces? Thanks for the tip though.
|
Well, it would be 13 search-and-replaces and then still one formula and column copy-and-paste (to convert the text to a date). And it took me about 90 seconds to do the formula.
The advantage of the formula is that you are less likely to make a mechanical error than doing a repetitive task 13 times.
But mostly it was with an eye towards this being something done more than once. If it is a one off then search and replace isn't much less efficient.