I appreciate that a lot Paul, your routine works really well in doing what I requested and in handling all the likely variation's.

Wish I had worded better though my full requirement, in that along with the zip in ColumnB, I also need the zip removed from the ColumnA data

I do apologize, and thanks again...