sort name records according to criteria

[-keevill-]

I have sheet of names and addresses but some of the rows do not have the
name title ( Mr / Mrs ) . i.e they only have the name J. Doe instead of Mr
J. Doe
I would like to prepare the list for mail merge in order to do this, I want
to split the list into 2 segments.
1 section of the rows of records containing full title and the 2nd section
containing the records which have no title.
How can I do this quickly without highlighting and cut/copy etc?
It's a list of several thousand records.

 

[Jarek Kujawa]

=IF(OR(LEFT(A1,2)="Mr",LEFT(A1,3)="Mrs"),"Mr/Mrs","")

then apply autofilter

ctrl+G, Special, select Visibles, copy to another sheet/location,
paste as values

do the same for NON "Mr/Mrs" with changed formula:

=IF(AND(LEFT(A1,2)<>"Mr",LEFT(A1,3)<>"Mrs"),"Mr/Mrs","")

 

[-keevill-]

=IF(OR(LEFT(A1,2)="Mr",LEFT(A1,3)="Mrs"),"Mr/Mrs","")

then apply autofilter

ctrl+G, Special, select Visibles, copy to another sheet/location,
paste as values

do the same for NON "Mr/Mrs" with changed formula:

=IF(AND(LEFT(A1,2)<>"Mr",LEFT(A1,3)<>"Mrs"),"Mr/Mrs","")

few more instructions needed please...
where do I insert this text/command ?

 

[Wigi]

These formulae (perhaps slightly changed to match your columns) should come
in a new column next to your table. Then you can use Sort or Autofilter.