How to Bulk Insert Text into Cells in WPS on macOS

Use Bulk Insert Text into Cells with 4 how-to topics, all of which are membership-related items; start from the How-to Index and jump to the task you need.

How-to Index

How-to Guide

1. Keep Content

Feature path: Member Exclusive → Smart Toolbox → Insert → Keep Content

1. Select the cell range you want to process.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related tools.
4. Click the Insert drop-down menu and choose Keep Content.
5. Select the content type you want to keep, such as Chinese characters, numbers, or English letters.
6. Click OK to apply the change.

Success Criteria

• The selected cells keep only the chosen content type.
• Unneeded content has been removed.
• The worksheet remains editable and can be saved.

Tips While Using

• Check the selected range before applying the change so unrelated cells are not affected.
• This is a membership-related feature and requires a signed-in account with the appropriate access.

2. Insert Text at Beginning

Feature path: Member Exclusive → Smart Toolbox → Insert → Insert Text → Insert Text at Beginning

1. Select the cell range where you want to insert text.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox.
4. Click the Insert drop-down menu, then open the Insert Text menu.
5. Click Insert Text at Beginning.
6. Enter the text you want to add in batches.
7. Click OK.

Success Criteria

• The specified text has been added to the beginning of each selected cell.
• The original content order remains unchanged.
• You can continue saving, undoing, or editing the worksheet.

Tips While Using

• Confirm the text before applying it so you do not add the same prefix twice.
• This is a membership-related feature.

3. Insert Text in the Middle

Feature path: Member Exclusive → Smart Toolbox → Insert → Insert Text → Insert Text in the Middle

1. Select the cell range where you want to insert text.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox.
4. Click the Insert drop-down menu, then open the Insert Text menu.
5. Click Insert Text in the Middle.
6. Set the insertion position, such as after the Nth character from the left or right.
7. Enter the text to insert and click OK.

Success Criteria

• Text has been inserted at the specified character position in the selected cells.
• The insertion position matches your setting.
• The rest of the original text remains intact.

Tips While Using

• Check whether the selected cells have suitable text lengths for a shared insertion position.
• This is a membership-related feature.

4. Insert Text at End

Feature path: Member Exclusive → Smart Toolbox → Insert → Insert Text → Insert Text at End

1. Select the cell range where you want to insert text.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox.
4. Click the Insert drop-down menu, then open the Insert Text menu.
5. Click Insert Text at End.
6. Enter the text you want to append.
7. Click OK.

Success Criteria

• The specified text has been appended to the end of each selected cell.
• The original content remains intact.
• The result can be used for export, copy, or save operations.

Tips While Using

• If you are appending a fixed label, check whether the same suffix is already present.
• This is a membership-related feature.