Swap Columns

Swap two columns from a delimited text. This tool can be very useful when rearranging the order of the elements in a single list. It works by splitting the text by column using the specified delimiter, swapping the columns, and then joining the columns back together.

Example

Change the format from surname, first name, middle name initial to first name, middle name initial, surname.

Swap column #1 with column #2, delimited by comma followed by space.

Robinson, Kenneth H.
						Harris, Martin S.
						Walker, Linda A.
					Lopez, Sandra K.

Output

Kenneth H., Robinson
						Martin S., Harris
						Linda A., Walker
					Sandra K., Lopez

You can then use Find and Replace Tool to get rid of the comma. Find , and replace with blank.

And then the final result would be

Kenneth H. Robinson
						Martin S. Harris
						Linda A. Walker
					Sandra K. Lopez

Revert Changes

Did you swap the wrong columns or use the wrong delimiter? Don't worry, you can revert the changes by using the undo/redo function under the Edit button.

Related Tools

• Split Text - Split a text into individual columns, or by a new line.
• Extract Column - Get a specific column from a delimited text.
• Concatenate Text - Combine or merge two lists/columns line by line.