Remove text between quotes, variable length and number of quotes

**JP Romano** · 10-14-2011, 09:30 AM

Hi all... I'm attempting to clean up some rather ugly strings, and would like to automate a process to clear out all the data with the exception of what's between quotations.

The strings are variable length, and could have anywhere from 0 to 6 sets of quotations.

For example

From this

Please Login or Register  to view this content.

I want to be left with

Please Login or Register  to view this content.

Because this will sit in the middle of a larger macro, I'd much prefer to do this with vba code than a formula, but if the formula is the way to go, I can work with it.

Thank you so much for any help!

**Andrew-R** · 10-14-2011, 09:42 AM

How's this for you?

Please Login or Register  to view this content.

**JP Romano** · 10-14-2011, 09:50 AM

Made minor modifications and it worked like a charm. THANK YOU!

**snb** · 10-14-2011, 10:05 AM

Please Login or Register  to view this content.

**Andrew-R** · 10-14-2011, 10:08 AM

Ah, snb, we don't seem to have been in a thread together for a while. I've missed you, but then I've a real soft spot for any line of code that begins Join(Filter(Split(Replace