ExcelBanter - Extract Last 4 Strings from text

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Extract Last 4 Strings from text (https://www.excelbanter.com/excel-programming/427405-extract-last-4-strings-text.html)

PumaMan

Extract Last 4 Strings from text

I need to extra the last 4 strings from a text that may range in length.

Example:
"123456789101" I need to extract only "9101"
"abc1 4321" I need to extract only "4321"

It will always be the last 4 of the text if that helps. I'd like to know
how to do it in Excel primarily, but VBA is fine too.

All times are GMT +1. The time now is 10:38 PM.