"left" , "right" or "mid" a range then find

Is it possible to reduce the length of each value to my desired range and do a find.

possible to right(range("A2:A9"),4).find("something") ? so that each of the values in that range that the find is looking at contains only the last 4 letters/numbers.

.Find is a method of a range and .right will return a string, so in essence. No.
If you don't have a huge range to search through one alternative is to loop and do something like:

Please Login or Register  to view this content.

If you have a load of cells you could use the find and findnext methods to jump through the cells with it and then test to see if it is within the last 4 cells.