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?