Split comma separated string/value to columns

Question

I have comma separated CODE value in column "A2" and "A3"

Screenshot 1

I want to split the comma separated CODE values to SP_1,SP_2 ... SP_10 columns like as the below screenshot

Screenshot 2

Is there any formula to do this?

Data, Data Tools, Text-to-Columns, Delimited, Comma, Destination: $B$2, Finish — , Apr 06 '17 at 04:55

score 1 · Accepted Answer · 2017-04-06T05:08:00.387

1

Data, Data Tools, Text-to-Columns, Delimited, Comma, Destination: $B$2, Finish

edited Apr 06 '17 at 05:08

answered Apr 06 '17 at 04:59

score 1 · Answer 2 · answered Apr 06 '17 at 08:02

1

The standard method is Text to Column Wizard, in addition you can use VBA code also.

answered Apr 06 '17 at 08:02

Rajesh Sinha

2 Answers2