VBA

From CleanPosts

Jump to: navigation, search

VBA

ExtractElement

File:ExtractElement2.png

Returns the nth item of a text string separated by a user-defined separation character.

Function ExtractElement(Txt, n, Sep)
         ExtractElement = Split(Application.Trim(Txt), Sep)(n - 1)
End Function
Personal tools
Strangers In Paradise