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.
Flash Fill Excel | CustomGuide
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.