Then assuming your first string is in A2, this formula should tell you if there is less than 10 digits (excluding brackets, spaces and dashes)....
![]()
=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),"(",""),")","")," ",""))<10
Then assuming your first string is in A2, this formula should tell you if there is less than 10 digits (excluding brackets, spaces and dashes)....
![]()
=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),"(",""),")","")," ",""))<10
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks