CLEAN Function
This function will removes or cleans the non printable characters from the given text.
Syntax: CLEAN(text)
Example: =CHAR(" ↑Excel☼ ")
Output: Excel
This function will removes or cleans the non printable characters from the given text.
Syntax: CLEAN(text)
Example: =CHAR(" ↑Excel☼ ")
Output: Excel
No comments:
Post a Comment