remove two letters when searching

[Christian via OfficeKB.com]

Good Morning,
Could someone help me out here? I'm do some research for our VR dept and I'm
trying to write a macro to make it easier and faster but how would I do a
kind of search where in my main workbook I have number 123 but when it's
doing the search in the other 5 workbooks the number is listed somewhere as
number AB123 so I would need to remove to characters during the search. any
ideas?

 

[Guest]

Use MID function.

abc = "ABC123"
mid(abc,3,len(abc))