I like to know if there is a formula that can be used to parse the name into three different fields.
Currently, I have the following scenario option:
Full name is listed in Column B (see how it is a free fall and the name could be in any format. I need to parse the name into First, Middle, & Last. The desired results are more structured & Organized
I have used the Text to column option but the way the data is, I don't get the right results 1/2 the time.
Any help is greatly appreciated.
Due to my office compute limitations I cannot install the Add-in so I am only showing a snapshot.
Currently, I have the following scenario option:
Full name is listed in Column B (see how it is a free fall and the name could be in any format. I need to parse the name into First, Middle, & Last. The desired results are more structured & Organized
I have used the Text to column option but the way the data is, I don't get the right results 1/2 the time.
Any help is greatly appreciated.
Due to my office compute limitations I cannot install the Add-in so I am only showing a snapshot.