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?

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?

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?

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