WPS ASC is a built-in text function in WPS Spreadsheet that converts full-width characters in double-byte character set languages to half-width characters; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
ASC is a built-in function in WPS Spreadsheet for text cleanup, character-width normalization, and formula-based processing on Windows. After you provide text, the function converts full-width characters in double-byte character set languages to half-width characters, which helps with later sorting, matching, and data cleanup.
Core tasks include:
- Insert ASC from the Insert Function dialog.
- Type the
=ASC(...)formula directly in a cell or in the formula bar. - Check the function syntax, parameter details, and help entry.
Common use cases include normalizing imported text, cleaning data that contains full-width characters, and checking formula syntax before applying it to a worksheet.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows PC |
| App version | A current version of WPS Office is recommended |
| Network | The local ASC function does not require a network connection to run, but downloading WPS Office, installing it, and opening online help require internet access |
| Other | WPS Office should already be installed, and WPS Spreadsheet should open normally |
Download & Installation
Before using the ASC function in WPS Spreadsheet, install WPS Office and open a spreadsheet file.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet, select any cell, and use the Formulas tab or the formula bar to enter a function |
Source: WPS Download Center
Compare with Alternatives
| Comparison item | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Core capability summary | WPS Spreadsheet provides the ASC function. You can insert it from the Insert Function dialog or type it directly in a cell to convert full-width characters to half-width characters. | Microsoft Excel provides ASC(text) to change full-width characters in double-byte character set languages to half-width characters. | Google Sheets provides ASC(text) to convert full-width ASCII characters and katakana to half-width characters. | Notion provides a formula system and syntax reference, but its official function list does not include a function named ASC. | Adobe Acrobat official documentation focuses on PDF and JavaScript automation rather than spreadsheet functions such as ASC. |
| Official source | — | ASC function | Google Sheets function list | Formula syntax & functions | Acrobat JavaScript Development |
Advantage: WPS combines worksheet formulas, the Insert Function dialog, and a built-in help entry for entering and checking the ASC function in one spreadsheet workflow.
Overall conclusion
If your main task is character-width conversion in a spreadsheet, WPS, Microsoft Excel, and Google Sheets all provide an ASC function. Notion and Adobe serve different product scenarios in their official documentation, so they are not direct replacements for spreadsheet ASC workflows.
Use Cases
| No. | Scenario | Suitable for | Main issue | How ASC helps |
|---|---|---|---|---|
| 1 | Normalize imported text | Data organizers | Mixed full-width and half-width characters affect display and later processing | Use ASC to convert target text to half-width characters |
| 2 | Fill formulas down a column | Spreadsheet users | Inconsistent text formatting across rows makes results harder to standardize | Enter ASC in the first cell and fill the formula down |
| 3 | Check formula syntax | New users | The function syntax and parameter format are not yet familiar | Use the Insert Function dialog to review syntax and help details |
Membership & Benefits
Free vs WPS Premium
ASC is a built-in function, and using the function itself is not restricted to membership.
| Capability | Free | WPS Premium |
|---|---|---|
| Use the ASC function | ✅ | ✅ |
| Insert ASC from Insert Function | ✅ | ✅ |
| Type ASC directly in a cell | ✅ | ✅ |
| Other account benefits | Depends on the current account plan | Additional services depend on the subscribed plan |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet formulas and text cleanup | Free | The ASC function itself is available without membership and fits routine spreadsheet work |
| Spreadsheet work plus additional office services | WPS Premium | Suitable if you also want access to more account-based office benefits |
How to Subscribe
- To review available membership plans, visit the WPS Office pricing page.
Source: WPS Office pricing page