Use Flash Fill · Click the cell to the right of the data you want to work with. · Type the first value you want to extract in the new column and press Enter.