This must be easy but I'm fighting with it for hours. Please help
I have lists of words like this one:
!BERLIN, !LONDON, !MADRID, !PARIS, !ROME, !ATHENS
I need a formula which will split these lines, each word in a separate cell, without the comas.
In the example attached, I need formulas in columns B-K, which will do this for up to 10 words for each row.
Thanks in advance!!
Bookmarks