Need a formula

[Mindrage]

Hi,

I need some help with a formula....

i have text in a column like louisfgfhi"correa"bgsdfif

is it possible to have a formula in the next column which will only bring the word in the inverted comma ....

Eg.

Column 1 column 2
asgbfdgfd"louis"dbsvdbgv louis

 

[Peter_SSs]

Try

=TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",100)),100,100))

 

[villy]

Try:

Sub getinv()
With WorksheetFunction
    st = .Search("""", Range("A2"))
    nw = Mid(Range("A2"), st + 1, Len(Range("A2")) - st)
    nd = .Sum(.Search("""", nw) + st, -1)
    sword = Mid(Range("A2"), st + 1, nd - st)
    MsgBox sword
End With
End Sub

 

[Peter_SSs]

Try:

Sub getinv()
With WorksheetFunction
    st = .Search("""", Range("A2"))
    nw = Mid(Range("A2"), st + 1, Len(Range("A2")) - st)
    nd = .Sum(.Search("""", nw) + st, -1)
    sword = Mid(Range("A2"), st + 1, nd - st)
    MsgBox sword
End With
End Sub

From the thread title I don't think vba is what is being requested. However, if it was, you might consider this more direct approach

Sub Extract()
    Dim s As String, a As String
    
    s = Range("A2").Value
    a = Split(s, """")(1)
    MsgBox a
End Sub

 

[villy]

Nice code peter first time I learn about split..
Thanks