I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential - IL - Waukegan...I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there is one name that looks like this: Coldwell Banker - NRT, so my "mid" formula doesn't apply. Can you help me out?
July 30, 2009 3:14 PM
July 31, 2009 3:27 PM