Hi,
For example, I have a string in cell A1. "10 Years, 3 Months"
I would like to use a formula next to the column to extract the '10' Years and Covert to Months (ie 10 X12).
Then extract the '3'Months and add to the converted years (ie 120 +3)
Answer would be 123 in cell B1.
Thanks
For example, I have a string in cell A1. "10 Years, 3 Months"
I would like to use a formula next to the column to extract the '10' Years and Covert to Months (ie 10 X12).
Then extract the '3'Months and add to the converted years (ie 120 +3)
Answer would be 123 in cell B1.
Thanks