extracting only the text from cells which are formatted in italics

Please Login or Register  to view this content.

Hello everyone,

I need to do a similar work, but my data doesn't start with italic characters. I tried this formula but don't work in my case. I was not able to adapt it.
Someone could help me?

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

Thanks in advance.

Carlos Guimarães,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

---

Do not post links to workbooks, upload directly to the forum.

Originally Posted by cditomaso

I am looking for the same. In my case, the data ends with italic characters. Did you find a solution?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread