separate two dates from a text string into two separate cells

[Tacrier]

Hi again!

I have a "Start and End Date" named column with text like this:

Sep 24/08-Sep 24/08
Apr 4/08- Apr 30/08
Feb 1/08-Feb 20/08
Dec 1/07- Dec 31/07

I would like create a column for the Start Date and another column beside it
for the End Date. How can I achieve this?

 

[Sean Timmons]

Data - Text to Columns
Delimited
Find -

 

[Tacrier]

Thank you again Sean Timmons, it worked!!

Before, I spent about three hours manually separating the dates and your
formula worked in 5 seconds lol

Awesome.

 

[Sean Timmons]

Oops!

Thank you again Sean Timmons, it worked!!

Before, I spent about three hours manually separating the dates and your
formula worked in 5 seconds lol

Awesome.