22 Mar 2020 ... 1. Using Flash Fill to Split Data - Separate Full Names · Click the cell to the right of the first name you want to separate · Use the Auto-fill ...