#VALUE! -
=--TRIM(RIGHT(SUBSTITUTE(TRIM(A3),":",REPT(" ",10)),10))
The above is the data in the #Value! cell via the formula bar.

"Glenn" wrote:

Copy the value from A3 (the one that results in #Value!) directly into a
response to this post. Do not re-type or edit in any way.

Steve wrote:
This
=--TRIM(RIGHT(SUBSTITUTE(TRIM(A3),":",REPT(" ",10)),10))
Gives me a #Value!
Also isnumber for that cell is false.

Thanks,

Steve

.