Flash Fill You may need to separate first and last names (or product names and numbers, or any other data) into separate columns. New Excel 2013 feature Flash Fill can help you quickly fill in all the data.