Hello all,

I am currently trying to find a way to substitute double quotes and equal signs on my imports, but also format the phone number properly. I have an auto-enter calc that replaces the double quotes and equal signs with a simple substitute, but I am unclear on how to then format the phone number to (XXX) XXX-XXXX right now the numbers are all jumbled. I figured maybe a let would work, but im not sure how to do the substitute calc with the let function.

Thank you for any help.

we have a ; missing at the end of the first row of text.

Let ( [ PN = Substitute ( Phone Number ; ["\"" ; ""]; ["=" ; ""])

;PN= Filter ( PN ; "0123456789" )

] ;

Case (

Length ( PN ) = 10 ;

"(" & Left ( PN ; 3 ) & ") " & Middle ( PN ; 4 ; 3 ) & "-" & Right ( PN ; 4 ) ;

Phone Number

) // Case

) //Let