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...
0

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...
0

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...
0

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...
0

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...
0

How to Quickly Extract Pictures From An Excel File

If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this....
51

How to Sum Data in Excel

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells...
0

Formatting a Range of Cells In Excel VBA

Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,##0.00" Accounting Range("A1").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"...
19