Parsing cells

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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)
 
Thanks Ron

Ron de Bruin said:
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)
Click to expand...
 
Back
Top