Microsoft Excel – Text Functions – CLEAN, CODE, VALUE and NUMBERVALUE formulas

In our previous Article, we have discussed few Text Functions in Microsoft Excel. In this Article, we will discuss few more Text Functions.

CLEAN Function

This function is used to remove all the non-printable characters from the given text. In ASCII character set, the codes from 0 to 32
are non-printable characters. This functions look for these characters in the given text and removes them to display the readable text.

CODE Function

This function is used to returns the numeric code of the given character.
If it is a text, it returns the numeric code of the first character.

VALUE Function

VALUE function is useful to convert the given numeric text (that means the text should have only numbers) into a number.
If you give a text with non numeric values, this function returns the #VALUE! Error.

NUMBERVALUE Function

This function also works like VALUE Function, but in a locale-independent way. When representing the number usually
the return value is based on the locale settings. Through this function we can pass our own values through decimal_separator and group_separator arguments; which are optional. If you are not pass these values, it will take the values from locale.

🙂 Sahida

Microsoft Excel – Text Functions – CLEAN, CODE, VALUE and NUMBERVALUE formulas

Leave a Reply

Your email address will not be published.

Scroll to top