How to pull out an older date...

**screenpath** · 11-14-2007, 04:39 AM

I need to pull out a date that is necessarly now but a part of a form such as...

Sunday, August 19, 2006 in session 3.

I want the August 19, 2006 to be pulled out of that text.

**oldchippy** · 11-14-2007, 05:31 AM

Try this, with your text date in A1, try this in B1

=LEFT(A1,FIND("in",A1,1)-2)

Result = Sunday, August 19, 2006

**screenpath** · 11-14-2007, 06:10 AM

Almost there..I didn't say it right.

Should have said....

Sunday August 19, 2006 in session 3.

Still, I don't want 'Sunday' or 'in session 3'...or 'Monday' or...

Just '08/19/2006' or whatever the date is in the text string.

Thanks again.