CLEAN Function

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

CODE Function

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

WIDECHAR Function

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 […]

CHAR Function

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

BAHTTEXT Function

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

ASC Function

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 […]

40 Very Useful Excel Keyboard Shortcuts You Should Know

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

How to Quickly Combine the Contents of Multiple Cells Into One Cell in Excel

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