RIGHTB in WPS on Windows: Introduction

WPS RIGHTB is a spreadsheet text function for extracting content from the right side of text by byte count; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	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

RIGHTB is a built-in function in WPS Spreadsheet on Windows for returning a specified number of bytes from the right side of a text string. When you type RIGHTB(, the formula area shows syntax guidance so you can confirm the required arguments while entering the formula.

This function is useful for:

extracting text from the right side by byte count, especially in mixed-language text;
entering formulas directly in a cell or in the formula bar for routine data cleanup;
combining with other functions, including nested formulas and cross-sheet references;
updating results when referenced data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection for local formula entry and calculation; internet access is needed for download, installation, and account-related actions
Other	You need permission to open and edit spreadsheet files

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, create or open a spreadsheet, select any cell, and type `=RIGHTB(` to confirm that syntax guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, `RIGHTB(text,num_bytes)` extracts content from the right side of text by byte count, and syntax guidance appears while you enter the function.	Excel provides the RIGHTB function to return text from the right side by byte count and explains DBCS-related counting behavior.	Google Sheets provides the RIGHTB function to return the right portion of a string up to a specified number of bytes, with syntax notes and examples.	Notion formulas support text functions such as `substring()` and `length()`, but there is no direct spreadsheet-style RIGHTB function for byte-based extraction.	Acrobat Desktop Help focuses on PDF creation, editing, and management rather than spreadsheet text functions such as RIGHTB.
WPS Advantages	Advantage: You can enter RIGHTB directly in a spreadsheet cell or formula bar and use syntax guidance during formula editing.	Compared with WPS: It offers a similar function, while the official page focuses more on Excel syntax and DBCS language behavior.	Compared with WPS: It offers a similar function and fits browser-based spreadsheet workflows.	Compared with WPS: Its formula system is designed for database properties and text logic rather than spreadsheet-style function entry.	Compared with WPS: Its official desktop help is centered on PDF workflows instead of spreadsheet text extraction formulas.
Official Source	—	RIGHT, RIGHTB functions	RIGHTB function	Formula syntax & functions	Acrobat Desktop Help

Overall Conclusion

If your main task is extracting text from the right side by byte count in a spreadsheet, WPS, Microsoft Excel, and Google Sheets all provide a direct function path. WPS fits a familiar spreadsheet workflow on Windows, while Notion and Adobe are better aligned with database or PDF-focused work.

Use Cases

No.	Scenario	Suitable For	Main Need	How RIGHTB Helps
1	Extracting code suffixes	Data cleanup users	A code ending needs to be separated into its own field	Use RIGHTB to return the required bytes from the right side
2	Working with mixed-language text	Office users	Character-based extraction may not match the expected result	Use RIGHTB when byte count matters
3	Cleaning linked text fields	Finance and operations users	Results need to update when source text changes	Combine RIGHTB with other formulas
4	Filling a full column with one rule	Spreadsheet maintainers	Many rows need the same extraction logic	Enter RIGHTB once and fill down
5	Learning formula syntax	New spreadsheet users	Function arguments are not yet familiar	Type `RIGHTB(` and follow the syntax guidance

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
RIGHTB formula entry and basic calculation	✅	✅
Basic PDF features	✅	✅
Template downloads	Limited	More advanced template access
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Advanced PDF and some AI features	Limited access	More feature access is available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need RIGHTB and other standard spreadsheet formulas	Free	Core formula entry and routine calculation are available without membership
You also need more templates, cloud storage, or broader office features	WPS Premium	A better fit for users who work across documents, spreadsheets, PDFs, and added premium tools

Membership page: Get WPS Premium