text extraction

Hello everyone, I am trying to extract text in double quotes including the double no matter what position they occur in. for example: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 219px"><col...

I'm working with a huge data set of full names compressed into a single cell. I have another cell on the same line with the same name but the order of the parts may or may not differ. Parts are separated by spaces. So say Cell A1 is "John Q Doe" and cell C1 could be "John Q Doe", "Doe John...

Hi, I have a HUGE table of data and one column is all kinds of names that need to be parsed. I found two common types of arrangement. Last Name Mid initial first name (IE: Doe P Jane), the reverse order of that (Jane P Doe), and some variant that puts the mid initial at the end (Doe Jane P...

Someone please help me with the below scenario: A1: The War of Art by Steven Pressfield and Shawn Coyne (Nov 11, 2011) - Kindle eBook A2: Do the Work by Steven Pressfield (Apr 20, 2011) - Kindle eBook A3: How to Get the Raise You Want in 90 Days or Less: A Step-by-step Plan for Making It...