dj44
04-12-2016, 06:09 PM
Folks,
Good morning to all.:)
My excel spreadsheet has this column with lots of descriptions.
15904
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:doh:
please do advise me on this complex task.
and thank you very much for your time
DJ
Good morning to all.:)
My excel spreadsheet has this column with lots of descriptions.
15904
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:doh:
please do advise me on this complex task.
and thank you very much for your time
DJ