'%3e%3cstop%20offset='0'%20stop-color='%23391ef0'/%3e%3cstop%20offset='1'%20stop-color='%235dabff'/%3e%3c/linearGradient%3e%3clinearGradient%20id='icon-256-logo-ai-v1-g1'%20x1='0'%20y1='0.5'%20x2='1'%20y2='0.5'%20gradientTransform='matrix(-1.1603561542763454%20-2.029595748722483e-14%201.6849538795808504e-15%20-1.0775765482488853%201.1221874503325953%200.5387882741244623)'%3e%3cstop%20offset='0'%20stop-color='%2337b2fc'/%3e%3cstop%20offset='1'%20stop-color='%232052fc'/%3e%3c/linearGradient%3e%3clinearGradient%20id='icon-256-logo-ai-v2-g2'%20x1='0'%20y1='0.5'%20x2='1'%20y2='0.5'%20gradientTransform='matrix(-0.819979740677445%20-0.8603650957330012%200.7293719576520754%20-0.7384159647925725%200.45709711785879775%201.2338690791584153)'%3e%3cstop%20offset='0'%20stop-color='%23ffaa8f'/%3e%3cstop%20offset='1'%20stop-color='%23ee00ff'/%3e%3c/linearGradient%3e%3c/defs%3e%3cg%20transform='translate(0.19%203.56)'%3e%3cpath%20d='M9.6%200L14.8%200C15.09%200%2015.32%200.23%2015.32%200.52C15.32%200.59%2015.3%200.67%2015.27%200.74L8.2%2015.33C7.73%2016.28%206.77%2016.88%205.72%2016.88L0.52%2016.88C0.23%2016.88%200%2016.65%200%2016.36C0%2016.29%200.02%2016.21%200.05%2016.14L7.12%201.55C7.59%200.6%208.55%200%209.6%200Z'%20fill='url(%23icon-256-logo-ai-v0-g0)'%20fill-rule='nonzero'/%3e%3c/g%3e%3cg%20transform='translate(8.28%203.56)'%3e%3cpath%20d='M6.71%200C7%200%207.23%200.23%207.23%200.52C7.23%200.59%207.21%200.67%207.18%200.74L3.67%207.97L0%200.45C0.44%200.16%200.97%200%201.51%200L6.71%200Z'%20fill='url(%23icon-256-logo-ai-v1-g1)'%20fill-rule='nonzero'/%3e%3c/g%3e%3cg%20transform='translate(11.95%2011.53)'%3e%3cpath%20d='M8.5%201.55L11.71%208.17C11.83%208.42%2011.73%208.73%2011.47%208.86C11.4%208.89%2011.32%208.91%2011.24%208.91L6.05%208.91C4.99%208.91%204.03%208.31%203.57%207.36L0%200L6.02%200C7.08%200%208.04%200.6%208.5%201.55Z'%20fill='url(%23icon-256-logo-ai-v2-g2)'%20fill-rule='evenodd'/%3e%3c/g%3e%3c/svg%3e){kind=small}
SEARCHB is a text-position formula for WPS on Windows; 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 | Matches the number of membership-related rows in the index |
| Membership limit | None | All users can use this function |
| Version limit | None | Available in WPS DBSheet across versions |
About This Feature
Overview
SEARCHB is a common formula function in WPS Office on Windows for DBSheet. It is used to find the position of text within another text by byte count, and it is not case-sensitive. You can call it directly in a formula field, and it also supports nested use with other functions.
Core tasks include:
- Create a formula field and use SEARCHB to locate text positions.
- Fill in the function parameters in a reusable formula structure.
- Check results that update automatically after data changes or imports.
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 |
| Network | No mandatory network connection is required for local formula editing; internet access is needed for download and installation |
| Other | You need access to a WPS workspace that includes DBSheet and permission to edit fields |
Download & Installation
Before you use SEARCHB, install WPS Office on your Windows device and open a DBSheet for editing.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Launch WPS Office, open a DBSheet, and confirm that you can access Add Field and Formula |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | SEARCHB finds the position of text by byte count in a DBSheet formula field, is not case-sensitive, and supports nested use. | Excel SEARCH returns the starting position of text, is not case-sensitive, and supports an optional start position. | Google Sheets SEARCH returns the first matching position, ignores case, and supports the optional starting_at argument. | Notion formulas support text operations such as contains, test, and substring, but they do not provide the same spreadsheet-style SEARCH position function. | Adobe Acrobat supports text search in PDFs and across multiple PDFs, which is document search rather than a spreadsheet formula function. |
| WPS Advantages | Distinct: It fits directly into DBSheet formula fields and the result updates automatically after data changes or imports. | Compared with WPS: Excel provides a similar spreadsheet function, but the official page does not describe the same DBSheet field recalculation workflow. | Compared with WPS: Google Sheets offers a similar spreadsheet text-search function for cells. | Compared with WPS: Notion focuses on database property formulas and adjacent text matching rather than the same position-return formula pattern. | Compared with WPS: Adobe focuses on PDF content search instead of spreadsheet formula logic. |
| Official Source | — | Excel SEARCH function | Google Sheets SEARCH | Notion formula syntax | Adobe Acrobat search PDFs |
Overall Conclusion: If you need a spreadsheet formula to find text positions inside WPS DBSheet, SEARCHB gives you a direct formula-field workflow with nested use and automatic recalculation. Excel and Google Sheets offer similar spreadsheet search functions, while Notion and Adobe cover adjacent text-processing scenarios rather than the same formula use case.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Text position lookup | Table maintainers | They need to identify where a keyword appears in text | Use SEARCHB in a formula field to return the position |
| 2 | Nested formula logic | Data analysts | They need to pass text-search results into later calculations | Combine SEARCHB with other functions in nested formulas |
| 3 | Post-import checking | Collaborative teams | They want results to refresh after imported data changes | Save SEARCHB in a formula field so the result recalculates automatically |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Premium |
|---|---|---|
| SEARCHB function usage | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| PDF tools and more advanced capabilities | Basic features | More advanced features |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| You only need SEARCHB and other basic spreadsheet formula workflows | Free | This function itself has no membership restriction |
| You also need more cloud storage or more advanced office tools | WPS Premium | This is a better fit when you need both storage and broader office capabilities |
Source: WPS Office pricing page
How to Subscribe
- If you want to subscribe, visit: Subscribe to WPS Premium
Source: WPS Office pricing page