I have a column of data whereby the name is included in a single string of text, in format:
surname, title forename initial (note the comma after surname)
mouse, mr micky m
I need a way to spread these name elements out into 4 seperate columns. is this possible?
There can be 4 elements to each name, i.e. if the user has more than one middle name/initial, so it isnt restricted to 4 each time.