Datevalue

[PrinceExcel]

I have big data in column A of (011 12345 01/01/2019). Then I want columb B to get the dates only. I used the datevalue formula (=datevalue(right(a1;10)).It works but not on several cells with #value !. Data on column A are the same even on cells which has #value !. How can I fix those #value !?

 

[etaf]

on the cells with value - try in a new cell putting =right(a1;10) and see what you get out
if its a date it may change automatically to a date and show a number , but should come out as text

something is not quite correct in those A columns

 

[PrinceExcel]

It works.Thank you so much.

 

[etaf]

is the problem now solved