How to Use WPS Retain and Extract Text on macOS

Use Retain and Extract Text through 5 how-to topics, with 0 free topics and 5 membership-related topics; choose a topic from the index and follow the feature path and steps.

How-to Index

How-to Guide

1. Keep Content

Feature path: Membership Exclusive → Smart Toolbox → Text → Keep Content

1. Select the cell range you want to process.
2. Click the Membership Exclusive tab.
3. Open Smart Toolbox.
4. Open the Text drop-down menu and select Keep Content.
5. Choose the content type to keep, such as Chinese characters, numbers, or English letters.
6. Click OK to apply the result.

Success Criteria

• The selected cells keep only the chosen content type.
• The processed result is written back to the original cells.

Tips While Using

• This entry is available through the membership area.
• It is helpful to copy the original data before batch processing.

2. Remove Content

Feature path: Membership Exclusive → Smart Toolbox → Text → Remove Content

1. Select the cell range you want to process.
2. Click the Membership Exclusive tab.
3. Open Smart Toolbox.
4. Open the Text drop-down menu and select Remove Content.
5. Choose the content type to remove, such as Chinese characters, numbers, or English letters.
6. Click OK to apply the result.

Success Criteria

• The selected content type is removed from the chosen cells.
• The remaining text stays in the original cells.

Tips While Using

• This action changes the current selection directly.
• Confirm the content type before running a batch operation.

3. Extract Text from Beginning

Feature path: Membership Exclusive → Smart Toolbox → Text → Extract Text from Beginning

1. Select the cell range you want to process.
2. Click the Membership Exclusive tab.
3. Open Smart Toolbox.
4. Open the Text drop-down menu and select Extract Text from Beginning.
5. Enter the number of characters to keep from the start.
6. Click OK to apply the result.

Success Criteria

• Each selected cell keeps only the specified number of starting characters.
• Fixed prefixes can be separated quickly.

Tips While Using

• If the number is larger than the text length, the available characters are kept.
• This works well for prefixes, region codes, and similar front segments.

4. Extract Text from Middle

Feature path: Membership Exclusive → Smart Toolbox → Text → Extract Text from Middle

1. Select the cell range you want to process.
2. Click the Membership Exclusive tab.
3. Open Smart Toolbox.
4. Open the Text drop-down menu and select Extract Text from Middle.
5. Set the starting position and extraction length.
6. Click OK to apply the result.

Success Criteria

• Each selected cell returns the middle segment based on the settings.
• The result matches the chosen start position and length.

Tips While Using

• The start position and length should match the structure of the original text.
• This is useful for fixed-format strings with a target field in the middle.

5. Extract Text from End

Feature path: Membership Exclusive → Smart Toolbox → Text → Extract Text from End

1. Select the cell range you want to process.
2. Click the Membership Exclusive tab.
3. Open Smart Toolbox.
4. Open the Text drop-down menu and select Extract Text from End.
5. Enter the number of characters to keep from the end.
6. Click OK to apply the result.

Success Criteria

• Each selected cell keeps only the specified number of ending characters.
• Fixed suffixes or trailing identifiers can be extracted quickly.

Tips While Using

• This is useful for order suffixes, ending codes, and similar patterns.
• Check sample data lengths before processing a full column.