Feb 28 2022 06:08 AM
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.
Feb 28 2022 06:14 AM