ASC function - Microsoft Support
This article describes the formula syntax and usage of the ASC function in Microsoft Excel. Description. For Double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax. ASC(text) The ASC function syntax has the following arguments: Text Required. The text ...
Insert ASCII or Unicode Latin-based symbols and characters
ASCII and Unicode character encoding enables computers to store and exchange data with other computers and programs. Below are lists of frequently used ASCII and Unicode Latin-based characters. For Unicode characters for non-Latin-based scripts, see Unicode character code charts by script.
Text functions (reference) - Microsoft Support
Lists Text functions, such as the Clean, Proper, and Trim functions.
TEXT function - Microsoft Support
It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.
ASC function - Microsoft Support
This article describes the formula syntax and usage of the ASC function in Microsoft Excel. Description. For Double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax. ASC(text) The ASC function syntax has the following arguments: Text Required. The text ...
Import or export text (.txt or .csv) files - Microsoft Support
To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu. There are two commonly used text file formats: Delimited text files (.txt), in which the TAB character (ASCII character code 009) typically separates each field of text.
Map XML elements to cells in an XML Map - Microsoft Support
To import and export XML data in Excel, an XML Map that associates XML elements with data in cells to get the results you want will be useful. To create one, you need to have an XML schema file (.xsd) and an XML data file (.xml). After creating the XML Map, you can map XML elements the way you want.
Sort data in a range or table - Microsoft Support
Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns.
Sort data in a table - Microsoft Support
In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort. Select a cell within the data. Select Home > Sort & Filter. Or, select Data > Sort. Sort A to Z - sorts the selected column in an ascending order. Sort Z to A - sorts the selected column in a descending order.
CHAR function - Microsoft Support
This article describes the formula syntax and usage of the CHAR function in Microsoft Excel. Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
SORTBY function - Microsoft Support
Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.