Excel Text Functions

This section will learn  how to use Excel’s Text functions such as: CHAR, CLEAN, FIND, LEFT, LEN, etc. CHAR – returns the character specified by a number (ASCII Value) CLEAN – removes all non-printable characters from a text string. CODE – returns the numeric ASCII value for the first character of a text string. EXACT – compares if two… read more »

Excel CHAR Function

This post will guide you how to use Excel CHAR function with syntax and examples in Microsoft excel. Description The Excel CHAR function returns the character specified by a number (ASCII Value) The CHAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The CHAR function is available in… read more »