This is done either by using a delimiter such as a comma, space or hyphen, or using fixed defined width to separate a text in the adjacent columns. read more text to columns text to columns Text to columns in excel is used to separate text in different columns based on some delimited or fixed width. Let us consider some examples to understand the splitting of cells with the help of the Text to columns in excel is used to separate text in different columns based on some delimited or fixed width.
The text to columns wizard can be accessed either from the Data tab or the shortcut “Alt+A+E” (press one by one). This property works well when all the substrings have a fixed length.