How to use the ASC function
Author: Oscar Cronquist Article last updated on March 27, 2018
The ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. This function is for double-byte character set (DBCS) languages.
Excel Function Syntax
ASC(text)
Arguments
| text | Required. Text value or a cell reference. |
Comments
If text does not contain any full-width letters, text is not changed.
Functions in 'Text' category
The ASC function function is one of many functions in the 'Text' category.
Converts full-width (double-byte) characters to half-width (single-byte) characters.
Converts a number to the corresponding ANSI character determined by your computers character set.
Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument.
Returns the corresponding number for the first character based on your computers character set. (PC- ANSI)
Concatenates values from multiple cells.
Joins text strings.
Checks if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters.
Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive.
Extracts a specific number of characters always starting from the left.
Returns the number of characters in a cell value.
Converts a value to lower case letters.
Returns a substring from a string based on the starting position and the number of characters you want to extract.
Repeats a specific text a chosen number of times.
Extracts a specific number of characters always starting from the right.
Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive)
Replaces a specific text string in a value. Case sensitive.
Returns a text value if the argument is a text value.
Converts a value to text in a specific number format.
Extracts a string after a specific substring in a given value.
Extracts a string before a specific substring from a given value.
Combine text strings from multiple cell ranges.
Splits a string into an array based on delimiting values.
Deletes all blanks or space characters except single blanks between words in a cell value.
Calculates a character based on a Unicode number.
Returns a Unicode number based on a character.
Converts a value to upper case letters.
Converts a text string that represents a number to a number.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form