Dear Expert,
I have used the OCR and convert the PDF file to EXCEL.

BpO21Jan200810:56
C Gr 5 Oct 2008 7:58

They display in 2 types which I cannot use "Text to Column" to split all
into individual columns.
What functions can I use so that I can capture the 2nd characters in the
cell please?
What functions can I use so that I can capture the 3nd characters and the
rest after the third characters please ?
First one is easy ... just Left(A1,1)

BpO21Jan200810:56
Then how about ? "P", "O","21Jan2008","10:56" ...

C Gr 5 Oct 2008 7:58
Also, how about this ?
Thanks so much