CODEWITHSUNDEEP
excelexcel-formula
user2843775
user2843775

Reputation: 25

Excel - Separate Comma List Into Cells Using a Formula

  1. I have a list of values: shoes, hats, umbrellas, towels, disks
  2. Need to separate list values into three different cells using a formula.

For example:

+-------+------+-----------+
| shoes | hats | umbrellas |
+-------+------+-----------+

I could use a different formula in each cell to accomplish this. Whatever the case, I need this to be done using a formula. Thank you all in advance.

Upvotes: 1

Views: 4389

Answers (1)

user4039065
user4039065

Reputation:

With shoes, hats, umbrellas, towels, disks in A2, put this into a column to the right.

=TRIM(MID(SUBSTITUTE($A2, ",",  REPT(" ", 999)), (COLUMN(A:A)-1)*999+1, 999))

Fill right for a total of three columns then fill down as necessary.

        Split CSV to three columns

Upvotes: 1

Related Questions