CHAR in WPS on Windows: Introduction

WPS CHAR is a text function used in multidimensional tables to return the character represented by a number; this guide covers 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	The tasks in this guide can be used directly

About This Feature

Overview

The CHAR function is a commonly used text function in WPS multidimensional tables. It returns the ASCII character represented by a number. You can use it directly in a formula field or combine it with other functions to build character conversion, text assembly, and conditional formulas.

Core capabilities include:

Create a formula field and enter a CHAR formula to generate character results automatically.
Follow the function format in the formula editor and complete the required parameter setup.
Combine CHAR with functions such as IF and AND to build more flexible formulas.

This function is useful for generating character markers in batches, inserting specific characters into text results, and adding character conversion steps to data-processing formulas.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for a stable table and formula-editing experience
Network	A network connection is needed when you open online tables, sync data, or access cloud files
Other	You need an editable multidimensional table and permission to add or edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, then open a multidimensional table and confirm that you can add a Formula field

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use CHAR in a multidimensional table formula field to return the ASCII character represented by a number, and combine it with other functions in the same formula.	Excel provides CHAR(number) to return the character specified by a number for spreadsheet formulas.	Google Sheets provides CHAR(table_number) to convert a number into a character according to the current Unicode table.	Notion provides database formulas and many text functions, but its public formula reference does not show a direct CHAR-style character-code conversion function.	Adobe Acrobat Help focuses on PDF creation, editing, and conversion workflows rather than spreadsheet formula functions equivalent to CHAR.
WPS Advantages	Advantage: You can configure CHAR directly in a table formula field and show results at the record level in real time. Distinct: It fits workflows that connect formula output with other fields in the same table.	Compared with WPS: Excel offers a similar function, mainly in worksheet cell formulas.	Compared with WPS: Google Sheets also supports direct character conversion and documents it with Unicode-based behavior.	Compared with WPS: Notion formulas are centered on database property calculations and do not publicly document a direct CHAR equivalent.	Compared with WPS: Adobe Acrobat is centered on PDF workflows and does not provide the same spreadsheet-formula capability.
Official Source	—	Excel CHAR function	Google Sheets CHAR	Notion formula syntax	Acrobat Desktop Help

Overall Conclusion

If your main task is converting numbers into characters inside formulas, WPS, Excel, and Google Sheets all provide a direct function path. Notion and Adobe Acrobat are oriented toward database organization or PDF workflows, so they are less aligned with this formula scenario.

Use Cases

No.	Scenario	Suitable For	Main Need	Solution
1	Generate character markers	Data organizers	Convert numeric codes into characters quickly	Enter CHAR in a formula field and return the matching character
2	Build combined text results	Table maintainers	Insert specific characters into formula output	Combine CHAR with text concatenation or conditional functions
3	Learn and test formulas	New users	Understand parameter format and result behavior	Enter sample formulas in the editor and review the result immediately

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic use of formula features related to CHAR in the current entry path	✅ Available	✅ Available
Some advanced PDF, AI, and extended benefits	May be limited depending on the page and plan	More items and higher quotas are available
Cloud storage	1 GB	20 GB or more depending on plan

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need to learn or use basic formulas such as CHAR	Free	The tasks in this guide do not require membership
You also need more PDF, AI, or cloud-storage benefits	WPS Premium	Suitable when you need broader suite benefits beyond formula use

WPS membership center: Subscribe now