To separate first and last names using delimiters: Excel will split the first and last names ... Flash Fill is a powerful tool that automatically fills in data when it detects a pattern in your ...