I have some configuration names that I need to split:
example:
Dervisevic A. [C] need to split into two columns Last Name and First Initial
Last Name First Initial Dervisevic A. [C]
Also the data is pretty bad, I also have some data in this manner as well that needs to be separated too (there is a period in between last name and first inital:
O'Brien.N NEW [C]
Last Name First Initial O'Brien N. NEW [C]