|Since your data is already in Column B, you must extract the last name into another cell.|
Have you tried the Data...Text To Columns feature? Use the "space" as the delimiter.
If you want to use a formula, you can try these:
For simple 2 string names such as "Anna Taylor", try this:
If you have names with 3 strings such as Anna Nicole Taylor, you can do it 2 steps by extracting the names twice, e.g.
First Name formula: Anna
Last Name Formula: Nicole Smith
First Name formula :Nicole
Last Name formula: Smith
There are also some longer formulas that will extract the middle and last names directly. You can Google around and find various versions.
You might also want to try this site:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.