Skip to Content
Menu
This question has been flagged
2 Replies
948 Rodiniai

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
Portretas
Atmesti
Best Answer

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

Portretas
Atmesti
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>)
Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
liep. 25
1333
1
birž. 25
1152
1
birž. 25
890
1
birž. 25
1811
3
kov. 25
2102