Hi there,
I was wondering if someone could help me create a formula so that if I have a Text field, it can automatically add a “( )” around the first 2 or 3 digits? I know I could use the phone number field option but I rather not.
EX: 1301234901 -->...
Thank you so much for the help!
I made some adjustments to your formula and it worked, so happy! Many thanks!!
Formula I used: IF(LEFT({text number}, " “),”(" & LEFT({text number}, 2) & “)” & MID({text number}, 1, 50))
