Greetings,
Up front, I am posting this question in both Access-Queries and Excel forums. I am using Access-Excel 97 SR2 at work, and Access-Excel 2000 at home.
I have a large Excel file where the addresses are all in one field (Address). Here are some examples:
807 E.South St. Apt.33 Crown Point, IN 46307
5269 Cedar Point Dr. G152 Crown Point, IN 46307
717 Moraine Trace #16 Schererville, IN 46375
8128 Mount Ct. #A Crown Point, IN 46307
I need this data broken into these fields:
Address = Street Address
City
State
Zip
I have phone numbers that need the dashes stripped out.
I have dates in the format mm/dd/yy that need to be mm/dd/yyyy.
I have names in Last, First format in one field...need these to be split also.
I've not found anything useful in the Excel forum, and I've not been able to get anything I've found in the Access-Queries forum to work the way I need it to.
Any help would be greatly appreciated. This info needs to be fixed before this Thurday morning...
Thanks in advance to all who reply !!!!!
Sincerely,
Bob in Indy.
Up front, I am posting this question in both Access-Queries and Excel forums. I am using Access-Excel 97 SR2 at work, and Access-Excel 2000 at home.
I have a large Excel file where the addresses are all in one field (Address). Here are some examples:
807 E.South St. Apt.33 Crown Point, IN 46307
5269 Cedar Point Dr. G152 Crown Point, IN 46307
717 Moraine Trace #16 Schererville, IN 46375
8128 Mount Ct. #A Crown Point, IN 46307
I need this data broken into these fields:
Address = Street Address
City
State
Zip
I have phone numbers that need the dashes stripped out.
I have dates in the format mm/dd/yy that need to be mm/dd/yyyy.
I have names in Last, First format in one field...need these to be split also.
I've not found anything useful in the Excel forum, and I've not been able to get anything I've found in the Access-Queries forum to work the way I need it to.
Any help would be greatly appreciated. This info needs to be fixed before this Thurday morning...
Thanks in advance to all who reply !!!!!
Sincerely,
Bob in Indy.