copy a number without space

%3CLINGO-SUB%20id%3D%22lingo-sub-3220807%22%20slang%3D%22en-US%22%3Ecopy%20a%20number%20without%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220807%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20copy%20a%20number(ex.%20100000)%20without%20space(ex.%20100%20000).%20The%20number%20which%20I%20need%20is%20copy%20from%20online%20site%26nbsp%3B%20which%20it%20generate%20for%20me%20in%20this%20format.%26nbsp%3BSo%20for%20use%20this%20number%20after%20in%20a%20formula%2C%20I%20need%20to%20erase%20the%20interior%20space.%3C%2FP%3E%3CP%3EA%20practical%20example%20in%20photos%20from%20attach.%20In%20the%20cells%20with%20green%20color%20i%20need%20to%20insert%26nbsp%3B%20the%20inputs%20dates%20and%20the%20cells%20with%20yellow%20color%20need%20to%20contain%20the%20wanted%20results.%3C%2FP%3E%3CP%3EIf%20I%20insert%20manually%20first%20number%20(100000)%20the%20formula%20works%20but%20if%20I%20insert%20with%20paste%2Fpaste%20special%20the%20number%20contain%20space%20(100%20000)%20and%20the%20formula%20generate%20a%20error.%3C%2FP%3E%3CP%3EWhat%20setting%20should%20I%20have%20enabled%20or%20what%20changes%20should%20I%20make%20so%20that%20I%20can%20automatically%20copy%20the%20first%20issue%20so%20that%20it%20no%20longer%20contains%20space%3F%3C%2FP%3E%3CP%3ETranslate%20with%20google%2C%20sorry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20anticipated%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVlad.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22error.png%22%20style%3D%22width%3A%20537px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351718i93071D06098B50C6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22error.png%22%20alt%3D%22error.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22output%201%20D7.png%22%20style%3D%22width%3A%20543px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351716i31AA717BFC0628FB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22output%201%20D7.png%22%20alt%3D%22output%201%20D7.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22output%202%20D8.png%22%20style%3D%22width%3A%20547px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351717i4928CAD3AB967D77%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22output%202%20D8.png%22%20alt%3D%22output%202%20D8.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3220807%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220830%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20a%20number%20without%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220830%22%20slang%3D%22en-US%22%3EYou%20can%20use%20SUBSTITUTE(D5%2C%22%20%22%2C%22%22)%20to%20remove%20the%20space%20(assuming%20it%20is%20a%20space%20and%20not%20a%20special%20character.%3CBR%20%2F%3EIf%20it%20still%20doesn't%20work%20you%20may%20need%20to%20wrap%20it%20with%20NUMBERVALUE()%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

 

error.pngoutput 1 D7.pngoutput 2 D8.png

 

1 Reply
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()