Convert from FNAME LNAME to LNAME, FNAME in Excel

As an analyst you will frequently receive data in FNAME LNAME format. This is poor data design — it does not allow you to sort the data A-Z by last name. In this video I will show you how to convert the list of names. 

Download the exercise file here.

 

capture

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: