Use this tool to split a text into two columns or more. You can also split text by new line. Please note that you must specify the delimiter whether that be a comma, space, or any valid character. Columns must be separated by the same delimiter and follow the same format or it will not properly extract and split the provided data. Undoing the concatenate function in Excel can be time-consuming. This tool can be handy when you're trying to unmerge a single-column text.