Is there a way to extract individual comma separated values from a cell and populate elsewhere in Go-CodePudding

Home > other > Is there a way to extract individual comma separated values from a cell and populate elsewhere in Go

Is there a way to extract individual comma separated values from a cell and populate elsewhere in Go

Time：06-06

I have a cell on one sheet of a workbook. Values can be separated by lines, or commas, whichever would make this easier.

On another sheet, I would like to display these values in different cells, individually.

Basically I would like to take this:

CodePudding user response：

try in D151:

=INDEX(IFEROR(TRIM(SPLIT(B151:B, ",")&" "&SPLIT(C151:C, ","))))