I've read all of the post and I don't think this one has been answered. I have a field that has CITY ST. I need to break them out into two fields. No commas just a space between CITY and ST. I've already done the ST as that was the easy part. Also, the solution needs to be something I can put into a query. Thanks for your help.