Hi everyone. Can you please help me to solve my problem. I have series of joined data in Year column with year-month separated by "-". What I want is to separate dates for From Year and To Year. I tried to use Left function =LEFT(H2,LEN(H2)-SEARCH("-",H2)). However, how do I go about if there is only starting date available in Year column (for example 14.4-). Once I use Left function, it gives me a blank result.
Another question is how do I convert that date into full date (for example 14.4 into 2014.04 or 99.9 into 1999.09)?