You are reading a single comment by @Drakien and its replies.
Click here to read the full conversation.
-
flashfill
Looks interesting, is the only thing it can do combine or separate text? Or does it recognise other patterns?
Drakien-
Don't know I'm afraid. I use it to separate text (though it does numbers too) - eg pulling out the colour part from a long column of SKU variants:
S/M / White
XXL / Black/White
L / Saffron
One Size / GreenGives me:
White
Black/White
Saffron
Green
etcWas using text to columns but always needed a fair amount of fiddling because of variants using / or space.
villa-ru
After a million years using excel, I have just discovered what the flashfill thing is doing and IT HAS CHANGED MY LIFE.