standardize names

You may want to standardize names in Excel if you’re combining multiple sources where the names come in different formats. Sometimes the first and last name are in different columns. Sometimes you have the full name – or the first and last name separated by a space. And sometimes you have the last name, comma,