Splitting Data Into Columns

**Adam845** · 10-04-2012, 06:19 PM

Hello!

I have a large database of names in various formations (first name, initial, last name; initial, first name, last name; initial first name, last name) [please see attached image].

However, what I need is just the person's first name in this cell. I've currently been splitting cell B and doing this manually, but I'm sure there is a more efficient way to do this (this list in particular has 5000+ names). It's tricky because some first names are preceded by an initial and others are preceded by an initial.

I appreciate any help you can offer!

Thank you!

Adam
DatabaseList.jpg

**Pete_UK** · 10-04-2012, 06:27 PM

It would help if you posted a sample workbook rather than a jpeg, so that we can try things out for you.

Pete

**Adam845** · 10-04-2012, 06:32 PM

Ok. Please see attached. Thanks!

DatabaseList.xlsx

**mike7952** · 10-04-2012, 06:53 PM

Try this on your uploaded workbook. Results will go into column h for now you can change at the bottom of the code after looking over the results and are happy with the output.

Please Login or Register  to view this content.

**Adam845** · 10-04-2012, 06:57 PM

That's perfect! Thank you so much, Mike!

Adam

**mike7952** · 10-04-2012, 07:00 PM

Your welcome.. Please refer to post #4 I was in the process of editing. You will see <=== Edited here where the code was edited. I noticed a little bug.