How to Split Text in Cells with Flash Fill in Excel 

You saved the day dude! Thanks so much, I could NOT get the cells to split for the life of me. This worked immediately.

GREAT HELP! Thanks Jon!!

Am so excited, am going to follow you religiously

Thanks for your help, that is brilliant!

Thanks for sharing Join. Great tip!

Thanks Jon. Flash Fill can certainly be handy, although I generally opt for formulas or Power Query to future proof my procedures. But, when you know it is a one-off situation, Flash Fill can often get it done quickly. Thanks for sharing :)) Thumbs up!!

Thank you John for the wonderful tip. I was doing it on my way (without Flash Fill) but it was laborious. This will save my time.

Thank you so much

Thank you Jon, your advise and simple explanations has made life so easy for me on this massive project i am working on - data migration for ERP system. Hope to see you very soon on one of your subscribed and paid for courses.....thanks

Great Tips On The Magic Of Flash Fill...Thank You Jon :)

super

1000 Thumbs up for you

Awesome!!

usefull! thks

Thank you for this video. I am working with a spreadsheet of over 2000 addresses. I'm looking for a way to split addresses Into several separate columns listing the street address, city, state, and zip code. Any advice?

i love youuuu

Hi Sir, i just want to ask if you can split address eg. Address, City, Province, Postal code ( Canada) or Address, City, ST, Zip code? Hopefully you can help me.

I have an Excel with full names but some of name are LLC & INC & Trust, I want to last name & first name except LLC, INC & Trust. How can I do this. Please help me out. Thank you

How is it different from Left, Mid and Right formulae ?

How to use flash fill