Excel Hack 77: Clean data in MS Excel (reorder first names and last names)
If you have ever needed to perform a lookup function and encountered Not Available (#N/A) errors due to wrong name ordering, you are going to love this hack. The wrong name order issue comes up commonly when working with human names – employee names or customer names – in Excel. Data analysts face this when