Poorly Comiled list (Sort needed)

[pmw19800]

hello All

i'm not sure this can be done with a formula...

Please see attached list,

This has been very poorly compiled and I need to try and sort it somehow
The names on the list seem to have the capital letters for the 1st names and last, is there a way it can be sorted by using the capital letters… please see row A for example results


Paul

[Kaper]

Having a look at your input data, I'd expect GIGO rule,

And the best you could do is to ask/download/create list with either clearly separated entries (with comma or so) or best - one entry per cell. Then you will be ready to use excel :-)

Sorry to say so, but in my opinion, either human or may be some sort of AI is needed to successfully deal with a list (as it is now).