Search code examples
libreoffice-calctext-to-column

Split comma separated string/value to columns

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

Screenshot 1

enter image description here

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

Screenshot 2

enter image description here

Is there any formula to do this?

Solution

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

    enter image description here