Main Profile

At A Glance

Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

See how to use Find and Replace, Text To Columns, and the function SUBSTITUTE and TRIM to extract First, Middle, Last Names from data that contains extra characters like commas, and dashes.
Length: 05:45

Contact

Questions about Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

Want more info about Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question