| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Now, THAT is slick.............well done Krishnakumar!
Vaya con Dios, Chuck, CABGx3 "Krishnakumar" wrote in message news:Krishnakumar.1s90md_1121493922.2683@excelforu m-nospam.com... Hi, Formula in A2 and copied down, ="jn"&--SUBSTITUTE(A1,"jn","")+1 where A1 houses jn51000001 HTH -- Krishnakumar ------------------------------------------------------------------------ Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138 View this thread: http://www.excelforum.com/showthread...hreadid=387666 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Threaded Mode
