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 réponses

Réponse 1 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
choise62
 
How had I not thought of that!!! ... thank you
0
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