Hi excelnovice

Try the following and assuming your data is in A1:A?

B1: =LEFT(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&1234567890))-1)

C1: =TRIM(MID(A1,LEN(B1),LEN(A1)-LEN(B1)-LEN(TRIM(RIGHT(A1,7)))))

D1: =SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(A1,7)),"am",""),"pm","")+0

Kevin

## Bookmarks