WORDGET

Returns the nth element of a string that uses a separator character.


Function WORDGET(Txt, n, Separator) As String 
     WORDGET = Split(Application.Trim(Txt), Separator)(n - 1)
End Function



© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext