Forum Discussion

VBogdan's avatar
VBogdan
Copper Contributor
Feb 28, 2022

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 formula, I need to erase the interior space.

A practical example in photos from attach. In the cells with green color i need to insert  the inputs dates and the cells with yellow color need to contain the wanted results.

If I insert manually first number (100000) the formula works but if I insert with paste/paste special the number contain space (100 000) and the formula generate a error.

What setting should I have enabled or what changes should I make so that I can automatically copy the first issue so that it no longer contains space?

Translate with google, sorry.

 

Thank you anticipated,

 

Vlad.

 

 

office 365

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Feb 28, 2022
    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()

Resources