How To Use The VBA Trim And Split Functions To Parse Names

In column A we have a list of random names

Our task is to divide the list of names into first and last names

We are going to parse (divide) the names by using the VBA “split” function. Then we will use the VBA Trim function to remove the excess spaces.

We will use a custom vba function to facilitate this task:

Remember that customized functions need to be placed in modules!

Now watch how it’s done:

Let me know if you have any questions.

****************************************************


 

Please remember to subscribe to my youtube channel

Been helped? Get these!

Facebooktwittergoogle_plusredditpinterestlinkedinmail