How to parse full name into first, mi, and last
Posted on 2006-05-30
I have a big list of names in a single Excel column. Some of them have first, mi, and last. Others don't have the middle initial.
Nancy H. Drew
Tom R Brown
Notice that some of the middle initials have a period and other don't. I want to parse this field into 3 separate fields. I've done something similar in the past using the instr function to determine where the spaces are and then using left, right, and mid. But I don't see instr in excel. Any ideas?