Hi there,

I have a species list with a large number of species names formatted in italics which also have the name of the person who classified the species in the same cell but not formatted in italics.

What I would like to do is to extract only the text in each cell which is formatted in italics i.e. only the species names.

Is this possible to do with a formula or macro? (see attached spreadsheet)


species_standardisation.xlsm