Split Columns
Split Columns helps you split cell content in collaborative spreadsheets into multiple adjacent columns based on delimiters, or convert text-formatted data into specified formats. It provides the tools you need to organize shared data efficiently, making your work more efficient and helping you accomplish tasks with ease. With Split Columns, you can split selected column data by tab, semicolon, comma, space, or a custom delimiter, treat consecutive delimiters as one, preview results in real time, set each output column to General, Text, Date, or skip import, and choose a destination area for the output. Whether you're cleaning irregular text data, converting values to dates or text, or preparing shared table data without overwriting existing content, Split Columns helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.