Parsing cells

[John]

Hi Folks,
I have data in cells which is OCR`d from my phone bill, and
some of the info is corrupt. Where I should be getting eg. 17 Nov 14:49 for
date/time I am getting O17 Nov 14:49 or
C17Nov 14:49. The reason is that there are unreadable icon characters to
signify day or night.

Questions:

1)How do I remove the faulty characters......they are always the first digit
in the date if they are there.

2)How can I seperate the date and time into two adjasent colums of cells
rather than their current format in one cell.

Any and all help greatly appreciated. John

 

[Ron de Bruin]

Hi John

You can use Data>Text to columns in the menubar to separate the date from the time
To remove the first character you can use the left function in a other cell like this

=RIGHT(A1,LEN(A1)-1)

 

[John]

Thanks Ron

Hi John

You can use Data>Text to columns in the menubar to separate the date from the time
To remove the first character you can use the left function in a other cell like this

=RIGHT(A1,LEN(A1)-1)