I have a column of names, most of which are FirstName LastName in format. Some, however are First MI Last. I need to convert these values into LastName Firstname MI. I have a formula that gets close, but doesn't account for the possible presence of a MI. Seems like I need to go backwards thru the string with a Search function to find the 2nd space for this to work, but can't. Or should I try it by parsing consecutive columns with incremental changes together???? Help!

Thank you