Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 204
- Office Version
- 365
- Platform
- Windows
I have A column of Org Names and addresses in Col A1
In Col b1 I want to extract Universities Names
In Col C1 I want the rest of the string data
To Note 1) All Universities begin and end within comma example , University of Roma, or , Sinchuan University, or la Universitate Malta,
2) Since the data has many variations, it would be preferable to use "uni" as keyword so that even other languages can be handled
Output
In Col b1 I want to extract Universities Names
In Col C1 I want the rest of the string data
To Note 1) All Universities begin and end within comma example , University of Roma, or , Sinchuan University, or la Universitate Malta,
2) Since the data has many variations, it would be preferable to use "uni" as keyword so that even other languages can be handled
| African Institute of Financial Markets Risk Management, Leslie Commerce Building, University of Cape Town, Rondebosch 7701, Cape Town |
| African Institute of Financial MarketsRisk Management, Leslie Commerce Building, University of Cape Town, Rondebosch 7701, Cape Town |
| Beijing Laboratory for Urban Mass Transit, Beijing 100124 |
| Centro Vito Volterra, Universit? di Roma “Tor Vergata”, Roma 0033 |
| CMUP DM-DCC, Faculdade de Ci?ncias da Universidade do Porto, Rua do Campo Alegre, 469-007 Porto |
| College of Mathematical Science, Sichuan Normal University, Chengdu, Sichuan, 60066 |
| Computer Engineering Department, Atilim University, Kizilcasar Mahallesi, Incek Golbasi, Ankara 06830 |
| Department of Computer Science and Engineering, National Sun Yat-sen University, Kaohsiung |
| Department of Computer Science, P. J. ?afárik University, Jesenná 5, 0454 Košice |
| Department of Electronics and Communication Engineering, Easwari Engineering College, Ramapuram, Chennai, Tamil Nadu 600089 |
| Department of Information Technology, Easwari Engineering College, Ramapuram, Chennai, Tamil Nadu 600089 |
| Department of Management Information Systems, College of Business and Economics, Qassim University, Buraydah 5152 |
| Department of Mathematics and Computer Science, St. Petersburg State University, 14th Line V. O., 9, Saint Petersburg 199178 |
| Department of Mathematics and Computer Science, St. Petersburg State University, 4th Line V. O., 29, Saint Petersburg 9978 |
| Department of Mathematics and Informatics, Faculty of Sciences and Technologies, University of Nouakchott, Nouakchott |
| Department of Mathematics and Statistics, Maynooth University, Naas, Co. Kildare, W3HW31 |
| Department of Mathematics and Statistics, University of Helsinki, P.O. 68, 00014, University of Helsinki |
| Department of Mathematics and Statistics, University of Winnipeg, 55 Portage Ave., Winnipeg, MB R3B 2E9 |
| Department of Mathematics, Eidgen?ssische Technische Hochschule, Rämistrasse 0, 8092 Zurich |
| Department of Mathematics, Indian Institute of Science, Bangalore 56002 |
| Department of Mathematics, Indian Institute of Technology Bombay, Mumbai 400076 |
| Department of Mathematics, Mar Athanasius College (Autonomous), Kothamangalam, Kerala |
| Department of Mathematics, Pavanatma College Murickassery, Kerala |
| Department of Mathematics, Saarland University, D-6623 Saarbruecken |
| Department of Mathematics, Toronto Metropolitan University and the Global Risk Institute |
| Department of Mathematics, Toronto Metropolitan University, and the Global Risk Institute |
| Department of Mathematics, University College London, Gower Street, London WC1E 6BT |
| Department of Mathematics, University College London, Gower Street, London, WCE 6BT |
| Department of Mathematics, University of Toronto |
| Department of Science and Humanities, Viswajyothi College of Engineering and Technology Vazhakulam, Kerala |
| Department of Statistics and Actuarial Science, University of Waterloo |
| Dhirubhai Ambani Institute of Information and Communication Technology, Gandhinagar, Gujarat |
| Dipartimento di Matematica e Applicazioni, ??R. Caccioppoli”, Università degli Studi, di Napoli “Federico II”, Via Cintia, 8026 Napoli |
| Dipartimento di Matematica, Universit? di Bologna, Piazza di Porta S.Donato 5, Bologna 4016 |
| Dipartimento di Matematica, Universit? di Pisa, Largo B. Pontecorvo, 5, 5617 Pisa |
| Dipartimento di Matematica, Univerversit? di Bari “Aldo Moro”, Via E. Orabona 4, Bari 70125 |
| Dipartimento di Scienze Matematiche ??G.L. Lagrange”, Politecnico di Torino, Corso Duca degli Abruzzi 24, Torino 049 |
| EDHEC-Risk Climate Impact Institute, 400 Promenade des Anglais. BP 36, 06202 Nice Cedex 3 |
| Engineering Research Center of Digital Community, Ministry of Education, Beijing 100124 |
| Faculty of Information Technology, Beijing University of Technology, Beijing 100124 |
| Gordon S. Lang School of Business and Economics, University of Guelph |
| Gordon S.?Lang School of Business and Economics, University of Guelph |
| Hubei Key Laboratory of Engineering Modeling and Scientific, Computing, Huazhong University of Science and Technology, Wuhan 430074 |
| IMAG, Univ Montpellier, CNRS, Montpellier |
| Indian Institute of Technology Bhilai, Raipur, Chattisgarh |
| Indian Institute of Technology Ropar, Rupnagar, Punjab |
| Institute of Analysis and Scientific Computing, TU Wien, Wiedner Hauptstra?e 8–0, 040 Wien |
| Mathematical Institute, Utrecht University, Heidelberglaan 8, 3584 CS Utrecht |
| Mehta Family School of Data Science and Artificial Intelligence, Indian Institute of Technology Roorkee, Roorkee, Uttarakhand |
| Rabobank, Croeselaan 18, 351 CB Utrecht |
| Riskworx (Pty) Ltd., 138 West Street, Sandown, Sandton 2031 |
| School of Computer Science, University of Waterloo, Waterloo, ON NL 3G1 |
| School of Computer Science, University of Windsor, Windsor, Ontario N9B3P4 |
| School of Mathematics and Statistics, Huazhong University of Science and Technology, Wuhan 430074 |
| School of Mathematics and Statistics, Qinghai Normal University, Xining, Qinghai 810008 |
| School of Mathematics, University of Bristol, Bristol BS8 1TW |
| Software Engineering Department, Atilim University, Kizilcasar Mahallesi, Incek Golbasi, Ankara 06830 |
Output
| University of Cape Town | African Institute of Financial Markets Risk Management, Leslie Commerce Building, Rondebosch 7701, Cape Town | |
| Universit? di Roma “Tor Vergata” | Centro Vito Volterra, Roma 0033 | |
| College of Mathematical Science, Chengdu, Sichuan, 60066 |
