Another option would be to create a calculated field similar to the following:
left(str([phone number]), 3) + '-' + right(str([phone number]), 4)
Thanks! This worked.
Thanks this worked. Very easy.
I appreciate the help and quick response!
You can also use the below
LEFT([PHONE NBR], 3) + '-' + MID([PHONE NBR],4,3) + '-' + RIGHT([PHONE NBR], 12)