ProductSolutionsTemplatesResources

ASC

Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.

Video field
Text

In Google Sheets, the function "=ASC(text)" is used to return the ASCII value of the first character in a text string.

ASCII (American Standard Code for Information Interchange) is a character encoding standard that assigns a unique numerical value to each character.

The syntax of the "=ASC()" function is as follows:

=ASC(text)

The "text" parameter is the text string or a reference to a cell containing the text for which you want to find the ASCII value.

For example, if you have the text "A" in cell A1, you can use the "=ASC()" function in another cell to get its ASCII value:

=ASC(A1)

This will return the ASCII value of "A," which is 65.

Please note that the "=ASC()" function only considers the first character of the text string.

If you provide a multi-character string, it will return the ASCII value of the first character and ignore the rest.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!