Feature Summary

The Retain and Extract Text to Cells feature is used to uniformly extract or remove content from text across multiple cells, improving text editing efficiency.

Feature Description

Feature Dimension Description
Membership Restriction Requires a membership subscription
Version Restriction No version restriction

Steps

Retain Content

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Text" dropdown menu → "Retain Content" option

  1. Select the cell range you want to process
  2. Click the Member Exclusive tab
  3. Select the Smart Toolbox option to open the Smart Toolbox tab
  4. Click the Text dropdown menu and select the "Retain Content" option
  5. Batch extract specified types of content from cells (e.g., keep only Chinese, numbers, or English) and delete all other content
  6. Click OK

imageimage

Remove Content

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Text" dropdown menu → "Remove Content" option

  1. Select the cell range you want to process
  2. Click the Member Exclusive tab
  3. Select the Smart Toolbox option to open the Smart Toolbox tab
  4. Click the Text dropdown menu and select the "Remove Content" option
  5. Batch delete specified types of content from cells (e.g., delete Chinese, numbers, or English) and retain all other content
  6. Click OK

image

Extract Text from Beginning

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Text" dropdown menu → "Extract Text from Beginning" option

  1. Select the cell range you want to process
  2. Click the Member Exclusive tab
  3. Select the Smart Toolbox option to open the Smart Toolbox tab
  4. Click the Text dropdown menu and select the "Extract Text from Beginning" option
  5. Extract a specified number of characters from the beginning of the cell text, suitable for extracting fixed prefixes
  6. Click OK

image

Extract Text from Middle

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Text" dropdown menu → "Extract Text from Middle" option

  1. Select the cell range you want to process
  2. Click the Member Exclusive tab
  3. Select the Smart Toolbox option to open the Smart Toolbox tab
  4. Click the Text dropdown menu and select the "Extract Text from Middle" option
  5. Extract a specified length of characters from a specified starting position in the cell text, suitable for extracting middle segments
  6. Click OK

image

Extract Text from End

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Text" dropdown menu → "Extract Text from End" option

  1. Select the cell range you want to process
  2. Click the Member Exclusive tab
  3. Select the Smart Toolbox option to open the Smart Toolbox tab
  4. Click the Text dropdown menu and select the "Extract Text from End" option
  5. Extract a specified number of characters from the end of the cell text, suitable for extracting fixed suffixes
  6. Click OK

image