Remove spaces within a number and removing round brackets

[EzzEldean]

Hello everyone, I hope everyone is doing well.

I need your help to find a formula to remove spaces within a number or a word, just to make Excel understand that it has to search for the space and then remove it and also to search for the brackets and remove them as well.

Example: cell A1 has " 220 200(818) " I want a formula to fix this and make it like this: "220,200,818" or like this: "220200818."

 

[rakesh seebaruth]

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, " ", ","), "(", ""), ")", "")

 

[EzzEldean]

Thank you for your reply. Is there any other formula other than this one in case the numbers or the letters differ, whether in counts or spaces?

 

[Fluff]

Another option

Fluff.xlsm
	A	B
1
2	220 200(818)	220,200,818
3	1234 abcd (23456)	1234,abcd,23456
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A2, "(", " "), ")", " ")), " ", ",")