How To Parse With The VBA Split Function

So you get a list of names and your boss wants you to separate the last name and the first name into different columns.
Many time you want to do this so you can sort by either the first name or last name columns.

You can use the vba “split” function for this purpose.

Step 1:
Find out the last row in your list.


Step 2:
Go into the VBE editor and set up a module with a For loop.

Press Alt + F11
Right Click and insert module.

Add this code to your module:

After you run the code (Press F5 on your keyboard), you’ll have parsed your columns!


Let me know if you have any questions

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.


Please remember to subscribe to my youtube channel

Been helped? Get these!