extract char x to char y of a cell

[cpliu]

If you have a cell "Feb 23 2010 4:11PM", how do extract Feb 23 (char
1 to 6) and 4:11 (char 13 to 16) out of that cell.
=LEFT(A1, 6) works on the first part, but I can't find a way to grab
from character 13 to chart 16.

Thnaks for the help,

 

[Dave Peterson]

Check your other post if you just want to change those text values to a real
date/time.

 

[Fred Smith]

=left(a1,6)&mid(a1,13,4)

Regards,
Fred

 

[helene and gabor]

=mid(a1,13,4)

assuming data in A1, to extract starting in col.13 a total of 4 chars.

Best Regards

Gabor Sebo

 

[cpliu]

That works. Thank you all for improving my Excel skill.