Hi Vickie,

Here is the more complicated approach, which is a little bit better behaved if the address is not correctly formatted:
Code:
[City]
IF((FIND(",",{Ship Address 3} ,1))<>0,TRIM(LEFT({Ship Address 3} ,(FIND(",",{Ship Address 3} ,1))-1)),TRIM({Ship Address 3}))

[State]
IF((FIND(",",{Ship Address 3} ,1))<>0,TRIM(MID({Ship Address 3},(FIND(",",{Ship Address 3} ,1))+1,99)),"")

You can copy and paste this into a text file and import them if you want.

If the field does not contain a comma, then the whole field will be placed in the CITY calculated column.
_________________________
Andrew Bates