Use this tool to get a certain column from a text that has spaces between words. It works by separating the list with a comma, a space, or any other delimiter, then taking only the column you want and getting rid of the rest. This is helpful when you want to separate a list that has been joined together or when you want to separate a single cell in a spreadsheet. You can take out any column as long as the format is the same (using the same delimiter).
The character(s) that separate each column is/are called a "delimiter." In the example given below, a space is used to separate the words.
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, AllenResult
Maria Ann John James Nancy Charles Henry Allen
To extract surnames instead of first names, extract column number 1 using 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.
- Split Text - Split a text into individual columns, or by a new line.
- Concatenate Text - Combine or merge two lists/columns line by line.
- Swap Columns - Swap two columns from a delimited text.