Simi/Kevin thanks for help, I don't want to drag this any longer, but i have three questions on the formulas

1) In the formula, C1: =TRIM(MID(A1,LEN(B1),LEN(A1)-LEN(B1)-LEN(TRIM(RIGHT(A1,7))))), as per your explanation the LEN (B1) gives the system the starting postion, then why do we have to do a LEN(A1) - LEN (B1) - LEN(TRIM....), if you know your starting position then all you need to do is TRIM the RIGHT end to figure out what the ZIP Code is, correct?

2) LEFT(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},**A1&1234567890**))-1), I understand here you are searching for a digit, but then why do you in the SEARCH function append A1&1234567890 ? aren't you supposed to be searching for a digit within the cell A1 only?

3) On the SUBSTITUTE formula "=SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(A1,7)),"am",""),"PM","")+0", how does adding a "+0" at the end insert "AM" to the result? and why are you doing a SUBSTITUTE within a SUBSTITUTE, can't this formula be written as SUBSTITUTE(TRIM(RIGHT(A1,7)),"am","")+0 ?