Extract text without a formula – Flash Fill In Excel 2013 and later, you can extract text without a formula using Flash Fill.FlashFill is a tool integrated into Excel, that runs in the background continuously.
