extract char x to char y of a cell

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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,
 
Check your other post if you just want to change those text values to a real
date/time.
 
=mid(a1,13,4)

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

Best Regards

Gabor Sebo
 
Back
Top