First and foremost, I want to thank who will help since I'm new with excel's formula
Here is my data:
SM NORTH EDSA PAG ASA 1, QUEZON CITY, 1105
4390 DAYAP COR. CUENCA STS., BRGY., PALANAN, MAKATI CITY
RM 313 LAPERAL BLDG. SESSION ROAD, BAGUIO CITY
I just want to extract the city...