All, would appreciate help with the following:
Each cell of a particular column of my spreadsheet contains a name and address of someone e.g.
Mr. John Smith department of food university of earth italy
or
Mr. John Smith, department of food, university of earth, italy
or
Mr. John Smith
department of food
university of earth
italy
My question: how can I extract the phrase containing the word 'university' [here, 'university of earth' ] into a new column?
many thanks in advance - cathal
Bookmarks