View original (French)

REMOVE SPACES IN MULTIPLE CELLS

Solved
taklia Posted messages 50 Status Member -  
taklia Posted messages 50 Status Member -
Hello everyone,

I am processing statistics in Excel 2013, which are extracted from software. These are customer files with the amount of their purchase. (about 1000 rows per month)
The amounts were extracted in "Standard" format like this:
99.00 [space]€
I would like to convert it to a number, but Excel does not recognize them as such.
With the ctrl+H formula, I have already managed to give it this form:
99.00 [space]
but I can't remove the space with the ctrl+H formula
Does anyone have a solution?
Thank you very much!!!

Configuration: Windows / Edge 14.14393

1 answer

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    This space is a non-breaking space and to remove it with ctrl+h you type alt+255
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    1
    1. taklia Posted messages 50 Status Member
       
      That's good! I found it thanks to the term "non-breaking space" you gave me :)
      I copied/pasted the specific space and pasted it into my search, then replaced it with *nothing*
      Thank you and have a great weekend!
      0