I have a column with comma delimited values which look like this:
Thursday 9-10
Thursday 7-8
Thursday 8-9, Thursday 9-10
Thursday 8-9, Thursday 9-10, Thursday 7-8
...
(edited added one more example)
I wanted to get each of the values so I decided to use split
like so:
=if(iserror(find(",",A1)), A1, split(A1, ","))
And it returns the following:
Thursday 9-10
Thursday 7-8
Tuesday 8-9 Saturday 9-10
Tuesday 8-9 Saturday 9-10 Friday 7-8
(edited added one more example)
It seems to me that the split function is not reading the cell as plain text (even though I formatted it to plain text) but as a date and then splitting on that basis.
Can someone explain to me why this is happening and how I can get it to ignore reading it as a date?
I have tried to concatenate the cell to a string with "" & A1
but that fails as well.
P.S. The first two values are returned as-is because there are no commas in those cells.