I have a table, a single column with both Cityname and Stateabbreviation in this
format:
Cityname, Stateabbreviation
or if you prefer:
Miami, FL
I want to separate this column in two separte columns. Easy enough to update the
Stateabbreviation using the Right$(,2) command but what about the Cityname part? I'm
sure to have seen it before put couldn't put my hands on it in the archive something
about using the "," as a delimiter...
Gilbert Hach�
Solutions Consortech Inc.
6300, Auteuil, Bureau 505
Brossard, Qu�bec, Canada, J4Z 3P2
T�l/Tel. : (450) 676-1555 Ext. 211
T�l�copieur/fax : (450) 676-8851
Courriel/email: [EMAIL PROTECTED]
