Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
1184 Tampilan

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
Buang
Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

"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
Buang
Post Terkait Replies Tampilan Aktivitas
1
Jul 25
1694
1
Jun 25
1409
1
Jun 25
1210
1
Jun 25
2406
3
Mar 25
2442