Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a cell you want to pull out of that cell and will then display that word. This is a very easy to use function that replaces having to use many complicated text manipulation functions in Excel. To use this user defined function (UDF) you only need to input the location of the cell with the text, the number of the word in the cell (counted from left to right) and the delimiter, if that is something other than a space.
Function GETTEXT(Text As Variant, N As Integer, Optional Delimiter As Variant) As String
If IsMissing(Delimiter) Then
Delimiter = " "
End If
GETTEXT = Split(Text, Delimiter)(N - 1)
End Function