Description The CODE function returns a numeric code for the first character in a text string. If you want to return the character specified by the code number, please use CHAR Function. Syntax CODE(text) Parameters Text Required. The text for which you want the code of the first character. Examples…
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 full-width (double-byte) characters. If you want to change full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters, please use ASC function. Syntax WIDECHAR(text)…
Description The CHAR function returns the character specified by the code number. Syntax CHAR(number) Parameters Number Required. A number between 1 and 255 specifying which character you want. The character is from the character set used by your computer. Examples The example may be easier to understand if you copy…
Description The BAHTTEXT function converts a number to Thai text and adds a suffix of “Baht.” Syntax BAHTTEXT(number) Parameters Number Required. A number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number. Examples The example may…
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 half-width (single-byte) characters. If you want to change half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters, please use WIDECHAR function. Syntax ASC(text)…
Table below is the 40 very useful Excel keyboard shortcuts (windows and Mac) you should know. See also: Complete List of Excel Keyboard Shortcuts. # Windows Mac Action 1 Ctrl 1 ⌘ 1 Format any selected object 2 Ctrl B ⌘ B Apply or remove bold formatting. 3 Ctrl I…
You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a first name and a last name. You can also use the CONCATENATE function to combine text from multiple cells into one cell, as shown in this post. But,…
If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. There’s no build-in function to do this in Excel. Here are two simple ways to quickly extract pictures from an Excel file. 1. Open your Excel file, click…