Use this tool to get a specific column from a delimited text. It works by splitting the list by comma, spaces, or any delimiter, grabs the only column that you want and deletes the rest. This is useful when you are trying to separate a concatenated list or when unmerging a single cell in a spreadsheet. You can extract any column as long as it follows the same format (using the same delimiter).
Delimiter is the character/s that separates each column. In the given example below, space is the delimiter.
Column1 Column2 Column3 Column1 Column2 Column3 Column1 Column2 Column3
Extract first names - column number 2, delimited by comma followed by space.
Collins, Maria Ann Doe, John Garcia, James Smith, Nancy Wright, Charles Henry Young, Allen
Maria Ann John James Nancy Charles Henry Allen
To extract surnames instead of first names, extract column number 1 using a comma as a delimiter.
Did you put the wrong column number and/or delimiter? No worries, you can use the undo/redo function under
Edit button to reverse the extraction.