Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
Microsoft Excel for analysts skills include Power Query to trim spaces and merge columns, so you automate cleaning steps and ...