View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Extract Last 4 Strings from text

Both in Excel and VBScript RIGHT() will work..

Msgbox Right("123456",4)

If this post helps click Yes
---------------
Jacob Skaria


"PumaMan" wrote:

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.