Extracting only the text from cells which are formatted in italics

[Carlos Guimarães]

Hello everyone,

I have a species list with a large number of species names formatted in italics which also have other information in the same cell but not formatted in italics. It seems to me that it only works when the content cell start with italic words. I tried the following formula but don't work in my case because the content of my cells don't start with words formatted in italic. I was not able to adapt it.

Please Login or Register  to view this content.

Someone could help me?

In this link is a sample of my data:
https://www.dropbox.com/sh/jwa51naj9...Q-8NNoFZa?dl=0

Thanks in advance.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Carlos Guimarães]

I don't know how to thank you, Greg M.
You helped me a lot!

Have a great weekend.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

Glad I was able to help.

By the way, if you want to ensure that the function returns only the FIRST italic string (I don't know if there will ever be more than a single italic string) then use the following version:

Please Login or Register  to view this content.

The additional code has been highlighted.


Best regards,

Greg M