Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
883 Weergaven

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
Annuleer
Beste antwoord

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

Avatar
Annuleer
Beste antwoord

"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
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
1
jul. 25
1196
1
jun. 25
1078
1
jun. 25
784
1
jun. 25
1598
3
mrt. 25
1976