Convrert Long Text Date to Actual Date?

[NewYears1978]

I hvae some imported dates that get converted to text and are formatted like this

Please Login or Register  to view this content.

I think I have done this before using =DATE with LEFT or RIGHT commands, but it is not working out right this time.
I need to convert to actual date- in Format mm-dd-yyyy, don't need the time.

THANKS!

[AliGW]

What happens when you use cell formatting for this - short date?

[63falcondude]

Assuming that your text dates are always of the form MMM DD YYYY (and then the time), try this:

=DATEVALUE(LEFT(A1,6)&", "&MID(A1,8,4))

[chief_abound]

=datevalue(substitute(left(a1,11)," ",", ",2))

[ChemistB]

Try text to columns, fixed width, setting up the first column to cover the month day and year and setting the second column to not import.

[AlKey]

Or

Please Login or Register  to view this content.

Format as Date

v	A	B
1	Oct 18 2017 12:00AM	10/18/2017

[AlKey]

You may also try this one. It will fix the AM/PM issue.

Please Login or Register  to view this content.

[NewYears1978]

All the options work, crazy there are so many. I had it close..but I can never get the formulas in the right order >:D

Thanks!!!

I have to tell you guys, this is the best community I've ever been involved with. I am used to jerk gaming community..this place rocks.

[63falcondude]

Glad we could help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[NewYears1978]

Pls delete this, Posted in wrong thread