Hi Everyone,
I am looking for a creative way to separate a text string within a single cell.
e.g. Text:
2016-2018 Audi A3 Sportback e-tron 2018-2020 Honda Accord 2016-2016 Scion iA 2017-2018 Toyota Yaris iA
I am looking for any possible way to split the text or insert a line break at every instance of a combination of years occur,
in the above sample text we have 3 such instances 2018-2020, 2016-2016 & 2017-2018
The expected output as follows within the same cell:
2016-2018 Audi A3 Sportback e-tron
2018-2020 Honda Accord
2016-2016 Scion iA
2017-2018 Toyota Yaris iA
Bookmarks