C
Carolina
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
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