Feature Summary

The Text to Columns feature is used to split the content of a single cell into multiple columns based on a specified delimiter or fixed width. It is commonly used for processing imported data.

Feature Description

Feature Dimension Description
Membership Restriction Some features require a membership subscription
Version Restriction No version restrictions

Steps

Text to Columns

Feature Entry

"Data" tab → "Text to Columns" button

  1. Select the data column you want to split
  2. Click the "Text to Columns" button in the Data tab
  3. Choose a splitting method:
  • Delimited
  • Fixed Width

image

Advanced Text to Columns in the Data Tab (Membership required)

Feature Entry

"Data" tab → Dropdown menu below the "Text to Columns" button → "Advanced Text to Columns" button

  1. Select the data column you want to split
  2. Click the Data tab
  3. Click the dropdown menu below the Text to Columns button
  4. Click "Advanced Text to Columns"
  5. Choose a splitting method:
  • Fixed Characters
  • Specific Content
  • Character Type

image

Advanced Text to Columns in the Smart Toolbox Tab (Membership required)

Feature Entry

"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Advanced Text to Columns" button

  1. Select the data column you want to split
  2. Select the Member Exclusive tab
  3. Click the Smart Toolbox button
  4. The Smart Toolbox tab will appear
  5. Click the "Advanced Text to Columns" button
  6. Choose a splitting method:
  • Fixed Characters
  • Specific Content
  • Character Type

image

image

FAQ

Q1: Will Text to Columns overwrite existing data?

  • Solution: If the target area contains data that would be overwritten, it is recommended to perform the Text to Columns operation in blank columns.

Notes

  • Ensure there are enough blank columns in the target area before using Text to Columns
  • The splitting result can be previewed and confirmed
  • Supports setting the data format after splitting