How to extract the last word in a string with Excel VBA

[@2boy2k]

Can you please share the Macro Code, I would like to apply it to check if cell contains certain last word then flag them for deletion

[@StrategizeFinancialModelling]

Hey Anurag thanks for your message. The link to the source workbook is here for you to download. spreadsheetvault.com/last-word-in-a-string/