Phone = Filter ( Phone ; 1234567890 ) ;
"(" & Left ( Phone ; 3 ) & ") " & Middle ( Phone ; 4 ; 3 ) & "-" & Right ( Phone ; 4 )
That works perfectly, thank you!
I do not really understand HOW that works, I just know that it does!
The super talented, Mr Raybaudi's solutions does a few things:
The Let function sets Phone to a variable which is filtered using only the numbers 0-10. So the first thing it does is remove everything that is not a number. Then it puts that filtered variable back into the calculation with the parentheses and the - in the right spot.
The only problem you could potentially have is if someone types in a different amount of numbers then 10.
Thanks for explaining that Steve.