In your original post you said aaa_001 NOT aaa_aaa_001. Try this.

=VALUE(MID(G4,FIND("_",G4,FIND("_",G4)+1)+1,LEN(G4 )-FIND("_",G4,FIND("_",G4))))

--
Don Guillett
SalesAid Software

"Jayanthi" wrote in
message ...

I tried with that ... I could'nt get those
will you please provide the code....

Cell A1 conatins AM_CM_0001
Cell B1 conatins AM_CM_1000

GIven value is AM_CM_0050


need to compare the characters then have to check whether the given
value is in that range


--
Jayanthi
------------------------------------------------------------------------
Jayanthi's Profile:
http://www.excelforum.com/member.php...o&userid=30035
View this thread: http://www.excelforum.com/showthread...hreadid=497229