Want to separate words into columns but it's not always the same amount of words.

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.

If the date of birth immediately follows the name (of variable length), this could be used as an identifier for the end of the name as it will comprise numbers.

It would help, though, if you attached a sample Excel workbook, so we can see how your data varies.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as this does not work on this forum.

Hope this helps.

Pete

Hi, how would I add an identifier for the end of the name?