I'm importing phone numbers from an comma delimitated xl spread sheet that has a one in front of the phone number.
Once imported into filemaker the number is used to find which vendor the call was made to. However to achieve this it must be in the format
To format the phone number I have used
Let ( Num=Filter ( Phone Number ; 1234567890);"(" & Left (Num; 3 ) & ") " & Middle ( num ; 4 ; 3) & "-" & Middle ( Num ; 7 ; 4 ))
Which works fine
I just need the part that gets rid of the 1 at the beginning
Thanks for any Help