| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function to extract numbers
13133..13558 (-)(426bp) 13714..13995 (-)(282bp) match, exact, left, right, mid cannot help me extract the pairs of 13133, 13558; and 13714, 13995 is there any function rather than writing regular expression in VBscript (if any) to achieve the purpose? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function to extract numbers
=LEFT(A1,5)
to extract 13133 and =MID(A1,FIND(" (-)",A1,1)-5,5) to extract 13558 HIH On 16 Kwi, 10:36, "ela" wrote: * * * 13133..13558 (-)(426bp) * * * 13714..13995 (-)(282bp) match, exact, left, right, mid cannot help me extract the pairs of 13133, 13558; and 13714, 13995 is there any function rather than writing regular expression in VBscript (if any) to achieve the purpose? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function to extract numbers
hi ela
Have you tried =Left(A1,find(".",A1)-1) to get 13133 and =MID(A1,FIND(".",A1)+2),5) to get 13358 or, if you wanted them as a pair, comma separated, then =SUBSTITUTE(LEFT(A1,FIND(" ",A1)-1),"..",",") -- Regards Roger Govier "ela" wrote in message ... 13133..13558 (-)(426bp) 13714..13995 (-)(282bp) match, exact, left, right, mid cannot help me extract the pairs of 13133, 13558; and 13714, 13995 is there any function rather than writing regular expression in VBscript (if any) to achieve the purpose? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function to extract numbers
On Thu, 16 Apr 2009 16:36:57 +0800, "ela" wrote:
13133..13558 (-)(426bp) 13714..13995 (-)(282bp) match, exact, left, right, mid cannot help me extract the pairs of 13133, 13558; and 13714, 13995 is there any function rather than writing regular expression in VBscript (if any) to achieve the purpose? Data/Text-to-Columns can split that up Delimited Select <space <other . (enter a dot) Treat consecutive delimiters as one --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| Function to extract numbers from an alphanumeric cell | Excel Worksheet Functions | |||
| Extract Fractional Numbers as Numbers NOT Date | Excel Worksheet Functions | |||
Hybrid Mode
