If I change the sort options in a single field to be separated by anything
such as a full stop or space and then go to sort that field I only get the
option of
using paragraphs and could not sort by the second field first.

In other words if I have a first name and second name in one column. I
cannot sort by second name. I can only sort by the first field first.

eg
Fred Bloggs
Jo Smith
Thanks