View original (French)

Remove space in Excel cell

Solved
Vavaleroux Posted messages 11 Status Member -  
Vavaleroux Posted messages 11 Status Member -
Hello,

I am seeking your help because I am unable to remove the spaces in the "Débit" column, while I would like to sum several rows.

I went into the cell format to disable the thousands separator and I also tried using find/replace to remove the spaces, but nothing works.

I also tried converting the data, but that didn’t change anything either.

I am providing the file in question:
https://www.cjoint.com/c/IFvnkT05DMn

Thank you in advance for your help,
Best regards.
Vanessa

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    this is a non-breaking space, not a blank space
    for example for column B
    • go to cell B2
    • in the formula bar, copy the space after the 9
    • select the entire column B
    • press ctrl + h
    • in the window, at the top: replace: paste the copied space
    • at the bottom: put nothing and
    • replace all

    best regards
    1
    1. Vavaleroux Posted messages 11 Status Member
       
      A big thank you, I hadn't thought of copying/pasting the space.
      0