Splitting Names

[ryanhofrichter]

Hi all, I am facing an issue that is over my head:

I have a column of names (Column A) that include both individuals, spouses, and non-spouses, in a variety of formats (may or may not include middle names, may or may not combine spouses with shared last name, etc.). I'd like to create six columns to the right (Columns B-G) that display names found in Column A according to whether they are first, middle or last. So we'd have:

2020-08-05_12-18-51.jpg

I have completed the above example manually, but the actually worksheet contains thousands of records, and I'll need to utilize formulas.
How can I get Excel to recognize what is a first, middle, or last name in Column A when each cell is formatted differently?

If this is not possible, it would be enough for me to just have the first names, such that Column B would contain the first name of Person 1, and Column C would contain the first name of Person 2 (if applicable).

Thanks!

[oeldere]

Did you tried text to column and use a space as seperator?

[ryanhofrichter]

Thank you, it worked!

[MarvinP]

Hey Ryan,

Watch this video and see if you can do it without a formula.
https://www.youtube.com/watch?v=1KimYFzET1w&t=12s

[oeldere]

Glad I could help.

Thanks for marking the question solved.

You can add reputation by clicking on the star * add reputation.