Use excel to show formula. Please use Column K FixedPhone to solve ColumnL ActualPhone

Your manager looked at your new phone format and decided that thy want it a little different. Create a new column to the right of FixedPhone named ActualPhone. Use the TEXT function to take the data from the Phone column and format it. If the original phone number does not have an area code, the result should be formatted as XXX-XXXX. Example: 615-5555. If the phone number does have an area code, the result should be formatted as (XXX) XXX-XXXX Example: (615) 555-5555.

K L M Fi Fixed Phone ActualPhone Date 4 (209)5558104 20200815 7 (206)5552797 20200815 8 (817)5558758 20200815 1 (801)5557981 20200815 K L M Fi Fixed Phone ActualPhone Date 4 (209)5558104 20200815 7 (206)5552797 20200815 8 (817)5558758 20200815 1 (801)5557981 20200815