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.

--

-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","")

"Jarek Kujawa" wrote in message
...
=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 ?

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.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"-keevill-" wrote:


"Jarek Kujawa" wrote in message
...
=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 ?