I need to create a lot of check off sheets for my employees. But when I copy over their names and info into excel puts it all into one cell. I was originally going to copy and paste all of my employees information (I'm doing this for over 300 employees) and split it the info by space, then connect their names into one cell, but I ran into the problem of their names being different lengths. For example, sometimes the name will be "John Joseph Saunders" and other times just "John Johnson" the issue is, when I go to create a macro to split up their name into different columns, it will split the name with three names into three and the one with two into two...and then the info like birthdate is in column D for the person with three names and column C for the person with two names. I am unsure of how to properly fix this issue. Is there any way to efficiently separate their name and information and then reconnect their name? I would not like to do this for so many employees all by hand.