Split Comma Separated Values Into Columns With Text To Columns Function

Step 1: Select the range of cells you want to split values into columns, and then click Data > Text to Columns. See screenshot:

Step 2: In the first Convert Text to Columns Wizard dialog box, select the Delimited option, and then click the Next button.

Step 3: In the second Convert Text to Columns Wizard dialog box, only check the Comma box in the Delimiters section, and click the Next button.

Step 4: In the last Convert Text to Columns Wizard dialog box, select a cell for locating the splitting values in the Destination box, and finally click the Finish button. See screenshot:

Now all the values in selected cells which were separated by commas are split to different columns as bellow screenshot shown.