Forum Discussion
copy a number without space
Hello, I want to copy a number(ex. 100000) without space(ex. 100 000). The number which I need is copy from online site which it generate for me in this format. So for use this number after in a...
You can use SUBSTITUTE(D5," ","") to remove the space (assuming it is a space and not a special character.
If it still doesn't work you may need to wrap it with NUMBERVALUE()
If it still doesn't work you may need to wrap it with NUMBERVALUE()