To query out city names

[lizzywu]

Hi there,


I want to update a column called 'City' into anything which can be gotten from another column called 'Address' with detailed addresses filled in. For example, Address are 'Detroit, MI 48201' and 'Ann Arbor, MI 48106'. The nice thing is that all cities are in Michigan. If I want to separate the city names, how can I do it? Thank you very much.

[alansidman]

You could look at this video on data manipulation

http://www.datapigtechnologies.com/f...anipulate.html

Also see attached

Alan

[lizzywu]

Thank you so much, Alan.