Problems with formating text within a cell.

Hi Kyle_S365

Try:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G6,"(",""),")",""),"-","")," ",""),".","")+0

Change G6 to whatever cell has the number in it.

Here's the website I found the answer on if you need an explanation and info.

https://exceljet.net/formula/clean-and-reformat-telephone-numbers

I hope that this is your answer. Best wishes!

Cheers

Damien