I need to split a name field in a column that contains one or all of the
following components without consistency: courtesy title (i.e. Mr.), First
Name, Middle Inital and Last Name. Some examples of records in my column a
Mr. K. Kyle Mathis
Ms. Terri Mathis
Ms. Ellen E. Vallatini
Cole Vallatini
Nick A. Vallatini

I tried using the command "Data" "Text to Columns" but, with the
inconsitency in data, it split correctly in some place but incorrectly in
others. Any ideas?