MS Excel / VBA help thread

You are reading a single comment by @villa-ru and its replies. Click here to read the full conversation.

•

Drakien in reply to @villa-ru

flashfill

Looks interesting, is the only thing it can do combine or separate text? Or does it recognise other patterns?

•

villa-ru in reply to @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 / Green

Gives me:
White
Black/White
Saffron
Green
etc

Was using text to columns but always needed a fair amount of fiddling because of variants using / or space.

About

Avatar for villa-ru @villa-ru started