Split Columns

Split Columns helps you split the contents of one cell into multiple adjacent columns based on delimiters, or convert text-formatted data into specified formats. It provides the tools you need to organize collaborative worksheet data more efficiently. With Split Columns, you can split data by tab, semicolon, comma, space, or a custom delimiter, treat consecutive delimiters as a single separator, preview the split result, set each output column as General, Text, Date with a selected order such as YMD, or skip importing a column, and choose the target output range. Whether you're cleaning irregular text data, separating combined values into columns, or controlling how imported results are formatted, Split Columns helps you complete data preparation accurately. Choose the documentation below that best matches your needs to learn more.

1:53