Skip to Content
Menú
This question has been flagged
2 Respostes
863 Vistes

How can you remove extra space characters in range of cells?

  1. By using the 'Delete' function/option
  2. By using the 'Trim' function/option
  3. Both of them
Avatar
Descartar
Best Answer

There is no "Delete" Function in Odoo.
Only TRIM Function available.
Maybe option 2 is the correct answer

Avatar
Descartar
Best Answer

"Trim" is the best solution, except you want to do "REPLACE" formula.

You can either achieve through

  1. Interface
    1. Select the range of cells
    2. Click "Data" > "Data cleanup" > "Trim whitespace"
  2. Formula
    1. =TRIM(<here goes your range>)
Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de jul. 25
1190
1
de juny 25
1068
1
de juny 25
763
1
de juny 25
1567
3
de març 25
1963