Combine & Split columns with Excel's AI-enabled Flash Fill tool
Extracting data from a column or merging columns can be hard with formulas. Try writing a formula to get the last word of a full name column that may have double-barreled names and you'll be left with a very complicated Excel formula (see an example below), Flash Fill allows you to use machine learning built into Excel to extract information without formulas in an easy way.
Formula to extract last word: =IF(LEN(B4)-LEN(SUBSTITUTE(B4," ",""))=1,PROPER(RIGHT(B4,LEN(B4)-SEARCH(" ",B4))),PROPER(RIGHT(B4,LEN(B4)-SEARCH(" ",B4,SEARCH(" ",B4)+1))))