Jon.Bryant
Well-known member
For grouping and listing purposes, isn’t Order, Family and Genus enough without subfamilies and tribes. It is pretty easy to split the Genus name from the full Latin name in Excel in any list.
First use the formula =Find(“ “,A1) where A1 should be replaced by the cell reference of the name you want to split.
This gives a number representing the location of the space, then use =Left(A1,B1-1) where B1 is the cell reference of the number calculated in step 1.
I do wish however, that IOC would stop putting extinct signs in their species names and flag species and subspecies as extinct in a separate column. Otherwise (assuming you are interested in extinct Genus) you also need to do two search and replace actions - one for “_TT” followed by one for “ __T” with “” as the replacement text (where T should actually be the extinct cross character and _ a space.). This will delete all extinct signs from the names, the downside is then that you won’t know which birds are extinct!
First use the formula =Find(“ “,A1) where A1 should be replaced by the cell reference of the name you want to split.
This gives a number representing the location of the space, then use =Left(A1,B1-1) where B1 is the cell reference of the number calculated in step 1.
I do wish however, that IOC would stop putting extinct signs in their species names and flag species and subspecies as extinct in a separate column. Otherwise (assuming you are interested in extinct Genus) you also need to do two search and replace actions - one for “_TT” followed by one for “ __T” with “” as the replacement text (where T should actually be the extinct cross character and _ a space.). This will delete all extinct signs from the names, the downside is then that you won’t know which birds are extinct!