Wednesday, September 30, 2020

Asc function

For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.

Syntax

ASC(text)

Text     is the text or a column reference that contains the text you want to change. If text does not contain any full-width letters, text is not changed.

Examples

Formula

Description (Result)

=ASC(" excel excel excel excel ")

" excel excel excel excel "

=ASC("EXCEL")

"EXCEL"

No comments:

Post a Comment