View original (French)

Remove spaces in numbers (Excel)

Solved
choise62 -  
 Sam -
Hello,

I imported a text file into Excel containing numbers that have a space
for example 1 000
I can use the convert function to remove that space but
I have multiple lines and multiple columns and it's tedious in this case
is there another faster way?
choise62

Configuration: Mac OS X (10.11.6) / Safari 9.1.2

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    • select the field (or the entire sheet)
    • press Ctrl with h key
    • top box: "replace" type a blank
    • bottom box leave nothing and
    • "replace all"


    best regards

    18
    1. choise62
       
      How had I not thought of that!!! ... thank you
      0
    2. Kiwi > cocotte
       
      It didn't work for me either when I put a space in the "Search" box. However, copying/pasting the character that was bothering me (which looked like a space) worked. So what appeared to be a space for the thousands separator was not one, but another special character that still appeared blank.

      I hope I have been clear in my explanations...
      46