(b) Extract the name of the city in column C. The form of the entry in column A will remain the same. In other words, the city name will always appear between the second semi-colon and the comma that immediately follows it. Row 2 gives you an example of the expected answer. You have to find the correct functions that will produce these answers.

Name and address	Name	City
Justin Powers; 14 Flatbush Ave., Apt. 14-C; Brooklyn, NY 10124	Justin Powers	Brooklyn
Carla Stein; 4123 New Hope Ave., Apt. 3B; Durham, NC 27512	Carla Stein
Michael Brown; 25321 Lake Avenue; Bangalore, Karnataka 560032, India	Michael Brown
Michael Douglas; 201 Greenwood Lane; Bristol, TN 32145	Michael Douglas