Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
1164 Vistas

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
Mejor respuesta

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

Avatar
Descartar
Mejor respuesta

"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
Publicaciones relacionadas Respuestas Vistas Actividad
1
jul 25
1661
1
jun 25
1388
1
jun 25
1174
1
jun 25
2362
3
mar 25
2407