_:na68088b1ccc2442686e18ae8d9c429dcxb1
<http://schema.org/text>
"I like to know if there is a formula that can be used to parse the name into three different fields. \n\nCurrently, I have the following scenario option:\nFull 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\n\nI have used the Text to column option but the way the data is, I don't get the right results 1/2 the time.\n\nAny help is greatly appreciated.\nDue to my office compute limitations I cannot install the Add-in so I am only showing a snapshot."
<https://www.mrexcel.com/board/threads/text-to-column-using-a-formula.1188359/>