跳至内容
菜单
此问题已终结
2 回复
864 查看

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
形象
丢弃
最佳答案

There is no "Delete" Function in Odoo.
Only TRIM Function available.
Maybe option 2 is the correct 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>)
形象
丢弃
相关帖文 回复 查看 活动
1
7月 25
1190
1
6月 25
1069
1
6月 25
763
1
6月 25
1567
3
3月 25
1963