separate two dates from a text string into two separate cells

T

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?

:)
 
T

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. :)
 
S

Sean Timmons

Oops! :)

Tacrier said:
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. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top