In odoo 18, How can you remove extra space characters in range of cells?
A. By refreshing data without whitespace
B. By using the "Trim whitespace' option
C. Both of them
0
1 Answer
0
Best Answer
Answer: By using the "Trim whitespace' option
Explanation:
1. Open the spreadsheet from Documents > Spreadsheets.
2. Select the cells (e.g., A1:A3) with extra spaces.
3. Click Data in the top menu.
4. Select Data Cleanup and choose Trim Whitespace.
5. Example Before: " John Doe "
After: "John Doe"