Hi All,
Good day,
Would you please clarify my doubt i have a set of database list contains city info as well. my query is which formula will help me to extract the city name alone in the nearest cell. i have below mentioned the data. kindly have a look and help me to resolve the issue.
S No Address
1 419 MTH ROAD, PATTABHIRAM MADRAS
2 27 A,1 ST FLR,TRUNK ROAD, POONAMALLEE CHENNAI
3 CENTRE POINT, NO. 221 AND 222, LLOYDS ROAD, GOPALAPURAM CHENNAI TAMILNADU 600086
4 27 NEW MGR, MAIN ROAD, KANDANCHAVADI, PERUNGUDI MADURAI TAMILNADU 600096
5 50, ARYA GOWDA ROAD, WEST MAMBALAM BENGALORE TAMILNADU 600033
6 287, T.H ROAD, OLD WASHERMENPET, MUMBAI 600021
The result would be like
1 MADRAS
2 CHENNAI
3 CHENNAI
4 MADURAI
5 BENGALORE
6 MUMBAI
Thank you in advance, Please reach out to me if you have any doubts on this.
Regards
Rajuganapathy
Bookmarks