| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separating alpha numeric vlue
Narasimha, if you are still reading this thread, you might find the
alternate solution I posted to Ron of some interest. Rick "Narasimha" wrote in message ... thanks Rick "Rick Rothstein (MVP - VB)" wrote: if starts with numeric and ends with alpha for example 123MLN, then how? please suggest for this also Give this array-entered formula a try... =MID(A1,MIN(SEARCH(CHAR(64+ROW($1:26)),A1&"abcdefg hijklmnopqrstuvwxyz")),255) NOTE: Commit this formula by pressing Ctrl+Shift+Enter instead of just Enter. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating Numerical and Alpha Data in cells | Excel Discussion (Misc queries) | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| +1, Alpha *and* Numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Hybrid Mode
