İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
1241 Görünümler

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
Vazgeç
En İyi Yanıt

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

Avatar
Vazgeç
En İyi Yanıt

"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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
1
Tem 25
1771
2
Eyl 25
219
1
Haz 25
1486
1
Haz 25
1243
1
Haz 25
2518