Excel - Flash Fill and the use of MID(SEARCH
Multiple ways to extract text from a single cell, in the example we split first name, surname and middle name into multiple columns using flash fill and the MID + SEARCH formulas.
Formula used for the middle name: =IFERROR(MID(A2, SEARCH(" ",A2) + 1, SEARCH(" ",A2,SEARCH(" ",A2)+1) - SEARCH(" ",A2) - 1),"")
Text to columns video previously done: • Excel - Text To Columns