A feature that splits the contents of a single column into multiple columns based on a specified delimiter or fixed character width.
Probeer het met AIText to Columns is a data transformation tool located in the Data tab that parses a single cell's text into separate cells. It is commonly used to clean imported data, such as separating full names into first and last names or splitting comma-separated values (CSV) into distinct columns.
If cell A1 contains 'John,Doe', using Text to Columns with a comma delimiter will place 'John' in A1 and 'Doe' in B1.
Yes, you can press Ctrl+Z immediately after performing the operation to revert the changes.