Converting month in text format to date format

[Naomi]

Hello

I have a group of cells that has been copied from an HTML page. These cells contain dates such as Jun 20 2002 8:56 AM. How can I convert these cells to a Date format where they can be sorted? I've tried changing the format but that doesn't seem to work. Thank you!

 

[Peo Sjoblom]

Use D. McRitchie's Trimall macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--

Regards,

Peo Sjoblom

Hello,

I have a group of cells that has been copied from an HTML page. These

cells contain dates such as Jun 20 2002 8:56 AM. How can I convert these
cells to a Date format where they can be sorted? I've tried changing the
format but that doesn't seem to work. Thank you!

 

[Dave R.]

One way;

=--(TEXT(--(LEFT(A1,6)),"mm/dd/")&RIGHT(LEFT(A1,11),4))

you can format that as date and should do the trick.

Hello,

I have a group of cells that has been copied from an HTML page. These

cells contain dates such as Jun 20 2002 8:56 AM. How can I convert these
cells to a Date format where they can be sorted? I've tried changing the
format but that doesn't seem to work. Thank you!