Difference between revisions of "Documentation/How Tos/Calc: CLEAN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
| Line 32: | Line 32: | ||
* [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]] | * [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]] | ||
* [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]] | * [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]] | ||
| + | * [[Documentation/How_Tos/Calc:_UNICHAR_function|<div style="font-size: 120%;">Unichar]] | ||
* [[Documentation/How_Tos/Calc:_UNICODE_function|<div style="font-size: 120%;">Unicode]] | * [[Documentation/How_Tos/Calc:_UNICODE_function|<div style="font-size: 120%;">Unicode]] | ||
| − | |||
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | * [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | ||
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] | * [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] | ||
Revision as of 11:36, 29 January 2024
CLEAN
returns a text string with non-printable characters removed.
Syntax:
CLEAN(text)
- returns text with all non-printable characters removed.
- Spaces are not removed.
Example:
where cell A1 contains =CHAR(7) & "cat" & CHAR(8):
CLEAN(A1)
- returns cat. The 2 non-printable characters are removed.
LEN(CLEAN(A1))
- returns 3, the number of characters in cat.
See Also
