Description The CLEAN Function removes all non-printable characters from text. Use CLEAN on text imported from other applications that contains characters that […]

Description The CODE function returns a numeric code for the first character in a text string. If you want to return the […]

Description For Double-byte character set (DBCS) languages, The WIDECHAR function Changes half-width (single-byte) English letters or katakana within a character string to […]

Description The CHAR function returns the character specified by the code number. Syntax CHAR(number) Parameters Number Required. A number between 1 and […]

Description The BAHTTEXT function converts a number to Thai text and adds a suffix of "Baht." Syntax BAHTTEXT(number) Parameters Number Required. A […]

Description For Double-byte character set (DBCS) languages, The ASC function changes full-width (double-byte) English letters or katakana within a character string to […]

Table below is the 40 very useful Excel keyboard shortcuts (windows and Mac) you should know. See also: Complete List of Excel […]

You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a […]