Extract Column


About


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).

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

Basic Example


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
Result
Maria Ann
John
James
Nancy
Charles Henry
Allen

To extract surnames instead of first names, extract column number 1 using comma as a delimiter.

Revert Changes


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.

Related Tools


  • 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.