Column A contains names of authors for papers from a number of organizations in the format
Last Name, (comma ) then First Name initials
Column B contains the names of authors from a specific organization in the format, generally Last Name; (semicolon) then full first name. In some case, Last Name; (semicolon) first name initials.
All the names in column B are sub set from column A.
The Last Name is common between column A and B.
I am looking for a formula in Column C that produce the names in the format Last Name, (comma) first initials as in column A for organization X
The attached file provides sample of the massive data that I have.
Any help is greatly appreciated.
Bookmarks