EzzEldean
New Member
- Joined
- Nov 17, 2022
- Messages
- 18
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
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."
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."