| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove Text From AlphaNumeric
You are right.
-- Jacob (MVP - Excel) "Rick Rothstein" wrote: I don't think you need to concatenate the "0" onto the front of the MID function which means you can also remove a couple of parentheses. I believe this will work... =LOOKUP(99^99,--MID(A1,1,ROW($1:$10000))) You can save two additional characters by using the LEFT function instead of the MID function... =LOOKUP(99^99,--LEFT(A1,ROW($1:$1000))) -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... =LOOKUP(99^99,--("0"&MID(A1,1,ROW($1:$10000)))) -- Jacob (MVP - Excel) "Bam" wrote: Hi All, I have a colmun of Codes, of varying lengths that contains Letters at the end of each Code. The letters range from 1 single letter up to a word, again of varying lengths. I need to strip out all alpha letters and retain only the numeric numbers. Either a fomula or Macro. Many Thanks, Bam. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Numbers from Alphanumeric String | Excel Discussion (Misc queries) | |||
| Sort a text column that contains alphanumeric | Excel Discussion (Misc queries) | |||
| Removing Text from Alphanumeric values | Excel Discussion (Misc queries) | |||
| Removing text from Alphanumeric values | Excel Worksheet Functions | |||
| how to remove number from alphanumeric cell | Excel Worksheet Functions | |||
Threaded Mode
