Sorry for the time its taken to get back to you guys. Firstly thank you for everyones input. Having read through the thread the first formula I tried was 6String Jazzer's -


=AND(LEN(A3)=24,ISNUMBER(VALUE(LEFT(A3,9))),ISNUMBER(VALUE(RIGHT(A3,14))),MID(A3,10,1)="/")

This has worked exactly as required.

To clarify the DV was for 9 characters followed by a "/" followed by another 14 characters

Thanks again



Many Thanks