Good morning,

I have some data, 95% of which is in the correct format, displaying just times in each cell e.g. 09:30. However some cells also contain text, which I do not want. In the majority of cells the text appears after the time, so I thought I could just use an =LEFT formula to keep the time and remove the text after.

The =LEFT formula gives the below results. It works on the cells containing text but then changes the cells, which are currently in the correct format (just showing times), in to numbers and I cannot change this back to the correct format using.


Formula used is =LEFT(A2,5)


=LEFT.JPG


Any help or suggestions on other ways to achieve what I am trying to do would be greatly appreciated.

Many thanks
George