How to Use WPS Retain Extracted Text on Windows

Use Retain Extracted Text through 5 how-to topics, all of which are membership-related items; choose a topic from the How-to Index and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Keep Content

Entry path: Member Exclusive tab → Smart Toolbox → Text → Keep Content

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

Success Criteria

• Interface result: The selected cells keep only the target content type based on the chosen rule.
• Next action available: You can review the result, undo the action, or save the worksheet.

Tips While Using

• Membership: This feature requires an account with membership access.
• Common mistake: If the target range is not selected first, the result may not match your expectation.

2. Remove Content

Entry path: Member Exclusive tab → Smart Toolbox → Text → Remove Content

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

Success Criteria

• Interface result: The selected content type is removed from the selected cells in batches.
• Next action available: You can continue editing the remaining text or save the file.

Tips While Using

• Membership: This feature requires an account with membership access.
• Common mistake: Check the original data before deletion so needed characters are not removed by mistake.

3. Extract Text from Beginning

Entry path: Member Exclusive tab → Smart Toolbox → Text → Extract Text from Beginning

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

Success Criteria

• Interface result: Each target cell keeps only the specified number of characters from the start.
• Next action available: You can continue with code splitting, sorting, or export.

Tips While Using

• Membership: This feature requires an account with membership access.
• Common mistake: If the character count is larger than the text length, short cells may remain unchanged.

4. Extract Text from Middle

Entry path: Member Exclusive tab → Smart Toolbox → Text → Extract Text from Middle

1. Select the cell range that you want to process.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related tool panel.
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

• Interface result: Each target cell shows the middle segment based on the specified start position and length.
• Next action available: You can continue with field splitting, comparison, or analysis.

Tips While Using

• Membership: This feature requires an account with membership access.
• Common mistake: If the start position or length is not set correctly, the result may be blank or incomplete.

5. Extract Text from End

Entry path: Member Exclusive tab → Smart Toolbox → Text → Extract Text from End

1. Select the cell range that you want to process.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related tool panel.
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

• Interface result: Each target cell keeps only the specified number of ending characters.
• Next action available: You can continue with tail-number extraction, label cleanup, or export.

Tips While Using

• Membership: This feature requires an account with membership access.
• Common mistake: Consider backing up the original column before processing so the original text can be reviewed later.