PDA

View Full Version : Extracting Left function -String into Columns



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