Common questions about Retain and Extract Text usually involve membership access, processing results, and parameter settings; this FAQ includes 3 common questions and a short glossary.
FAQ
Why can’t I find the Retain and Extract Text entry?
- Make sure you are working in WPS Sheets rather than another WPS app.
- Check whether you are signed in with a WPS account that has membership access.
- Look for the Membership Exclusive area and the Smart Toolbox entry on the ribbon.
- If the entry is still missing, update to the latest WPS Office for Mac and check again.
What should I do if the original cell content changed after batch processing?
- These text tools apply directly to the selected cells.
- Copy the original data to another column or worksheet before processing.
- If you just completed the action, try Undo first.
Why is the result not correct when I use Extract Text from Middle?
- Check whether the starting position matches the structure of the original text.
- Check whether the extraction length is longer than the target segment.
- Test the settings on a small sample before processing the full range.
Glossary
| Term | Definition |
|---|---|
| Smart Toolbox | A tool collection in WPS Sheets that groups batch-processing features in one place. |
| Keep Content | A text-processing action that keeps only the selected content type and removes the rest. |
| Extract Text from Middle | A text-processing action that returns a fixed-length segment from a specified starting position. |