I have a very bad Excel sheet which I try to fix.
Instead of getting separated columns, I got lines which I separated into different columns using ''text to columns.''
Now I have a problem, because one of the columns has different length and I can't use text to columns in order to separate the data I need.
Here you can see the data I need to extract and the different locations in has:
This is how my column looks like, I need the dates like the one that marked in red, but as you can see, down in the list, the location of the dates is different, so I can't use the ''text to columns'' how can I solve it
;
and_
as the delimiters. If you don't want the delimiters to be removed, you will need to replace them after the split.