| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent help in excel macros
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| Customize macros Very urgent | Excel Discussion (Misc queries) | |||
| urgent help with lock excel macros!!! | Excel Discussion (Misc queries) | |||
| Excel macros help me ! very very urgent | Excel Programming | |||
| URGENT!!!!!!!!!!!!!!! Problem with macros in Excel | Excel Programming | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
