Folks,

Good morning to all.

My excel spreadsheet has this column with lots of descriptions.

as.png

I have some questions.

Now I have been fiddling about all evening and well i am still stuck after many hours and coffees needed to keep my brain alert to this task

1. I would like to extract the red line into column G

i have done this

=LEFT(F2,FIND("NameID",F2&"""")-1)

but that only gave me half of the string

2. For the blue i did this in Column H

=LEFT(F2,FIND("VFF",F2&"(1)")-1)

that did not work

i am not sure if i am meant to trim it some how?

The red and blue line have the same format - but they will be different lengths
The red line finishes with a " quotation mark
The blue line always finishes with a ) left bracket



3. I am hoping to have a final column lets say column I - that has the contents of column F2 minus the Red line and the blue line.(not sure if this can be done?)

I also tried many other long bracket type formulas but it got messy so i came back to this basic one that did something but has gone dud now

please do advise me on this complex task.

and thank you very much for your time

DJ