Is there a way to dynamically delineate an Excel text cell by semicolons such that the two words are then stacked in a column?
For example:
word1;word2
word3
becomes:
word1
word2
word3
I cannot use macros or any sort of script/wizards. And I need it to be a formula so that it updates automatically/dynamically.
Is this possible?