I have title, first and last name on column A
and
adress, city, state, zip on column B

I need to split all these into individual columns for purposes of a mail
merge.
My challenge is that I can't use text to column because the row contents are
so different: sometimes Ms., Mr and Mrs, no periods, spaces, PO Box vs
address, etc.

I need your wonderful help addressing all the possible variances.

An example is below:

Column A Column B

Ms. Vivianne Smith 2555 Caminito del Rocio Del Mar, CA 92014
Mr. Robert Jones P.O. Box 4425 Lexington, KY 40454
Mr. and Mrs. James Liles 2854 E Chrysanthemum St Silver Val, AZ 85557

Thanks in advance.

Carolina