View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PumaMan PumaMan is offline
external usenet poster
 
Posts: 15
Default 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.