A further explanation and free download of the Excel workbook can be found here https://spreadsheetvault.com/last-wor...
This macro will extract only the last word in a string across a selected cell range. A macro-based approach is preferable if we have a large data range.
This is a follow-up to an earlier video, "How to extract the first word in a string with Excel VBA", • How to extract the first word in a string ...