View Single Post
 
Old 04-06-2019, 08:19 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

If you can live with an xlsm file,
how about a User Defined Function (UDF) ?
Code:
Public Function LastTwo(Orig As String) As String
    Dim i As Long, arr
    arr = Split(Orig, " ")
    For i = LBound(arr) To UBound(arr)
        LastTwo = Trim(LastTwo & " " & Right(arr(i), 2))
    Next i
End Function
Attached Files
File Type: xlsm Extract_Last_Two.xlsm (14.8 KB, 16 views)
Reply With Quote