how to change format of specific text or number

[alipezu]

easy way to change text in cell A1 055-9578005 to (055)957-8005 and vise versa..


Thanks!!

[FDibbins]

If that really is what your cell contents look like, then they are text entries, not numeric, so that kind of formatting will have no affect on them. You will need to convert them back to numbers 1st

[FlameRetired]

Does this do what you are wanting? FYI: The apparent line feeds are what the code does to the below grid. The actual data is all one line in each cell.

Row\Col	A	B	C
1	055-9578005	(055)957-8005	In B1 :=TEXT(--LEFT(SUBSTITUTE($A1,"-",REPT(" ",99)),99),"(000)")&TEXT(--RIGHT(SUBSTITUTE($A1,"-",REPT(" ",99)),99),"000-0000")
2	(055)957-8005	055-9578005	In B2 :=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"-",""),")","-"),"(","")