Convert text date to start and end date

[fernipascual]

I would like to find an easy way to convert something like this (January 18 - February 2, 2019) stored in a single cell to start date and end date in separate cells. Here are a couple of examples:

January 18 - February 2, 2019
February 6 - 19, 2019

Thanks

 

[Phuoc]

Start date:

=--(LEFT(A1,FIND("-",A1)-2)&", "&RIGHT(A1,4))

End date:

=--IF(ISNUMBER(--MID(A1,FIND("-",A1)+2,1)),REPLACE(A1,FIND("-",A1)-4,4,""),REPLACE(A1,1,FIND("-",A1)+1,""))

 

[fernipascual]

Start date:

=--(LEFT(A1,FIND("-",A1)-2)&", "&RIGHT(A1,4))

End date:

=--IF(ISNUMBER(--MID(A1,FIND("-",A1)+2,1)),REPLACE(A1,FIND("-",A1)-4,4,""),REPLACE(A1,1,FIND("-",A1)+1,""))

Thank you. This is great help!

It works on 90% of what I'm trying to convert. I am noticing the examples below that return an error. I suppose I could use find/replace as well as trim to make everything consistent before applying the formula.

January 1 - 17, 2019. (period)
January 1 - 17, 2019_ (blank space)
January 1 – 17, 2019 (Em hyphen)

Thanks again!