We already are using a macro to clean up the excel file we are given each month so ideally we just want to add extra code to have to also separate the names so we do not have to do extra formula work and the last part is to split up these names but as previous post mentions there are a lot of Spanish names so there are multiple names not just first last.

The file has a combination of different name strings.



I basically want to get the first name and just the last name and ignore whatever is in the middle. Possible?