Hello! brand new to this forum, but not forums in general. Also relatively new to Excel, but know the basics.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have a big project that I'm working on for a possible future employer. The outcome of this project will be the deciding factor to if I get hired or not. So a speedy response is greatly appreciated.
I have ≈45,000 emails, last names, and first names in several (40-50) excel files. These files have more info then needed, so I've created one master file that has 3 columns. Last Name/First Name/EMAIL.
The files that I'm getting the information from are all a little different. Some already have these three columns that I can copy paste into the master, but some just have the contacts name in one cell (i.e. A1= John Smith)
Is there a formula that will separate words into two columns? (i.e. A1 = John, B1 = Smith)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Also is there a way to (after I have completed my master list) alphabetize the list based on Last Name, and have the other two columns (First Name/EMAIL) link to the Last Name row, so that everything in a row won't be lost? Similar to an application that has a "sort by: Name" function.
Thank you so much for your help!
Bookmarks