I need to paste the info on this page
http://en.wikipedia.org/wiki/List_of_parrots
I want to be able to copy and paste this info in my excel and then be able to bulk remover the scientific names of the birds, can some one help me get rid of the comma and scientific names in bulk after I paste them in my excel. Thank you so much
Give this a shot...
=LEFT(A1,FIND(",",A1,1)-1)
Where A1 is the parrot name and genus/species name.
Good luck!
starryknight64
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks