I received this as a .cvs and I am trying to format the info in Column A to look like the info in Column B. When I try to format cells and Special and phone number it does nothing. I was wondering if there was a formula to help me with this. Thanks in advance.
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 330-727-2707 | (330) 727-2707 | ||||
2 | 330-518-0459 | (330) 518-0459 | ||||
3 | 330-518-1262 | (330) 518-1262 | ||||
4 | 330-518-1577 | (330) 518-1577 | ||||
5 | 330-519-7052 | (330) 519-7052 | ||||
6 | 330-559-1695 | (330) 559-1695 | ||||
Sheet1 |