View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Regular Expression Help on syntax

On Fri, 8 Jan 2010 10:41:01 -0800, Jason
wrote:

Joel,

I tried using your suggestion, but it won't pull any numbers, much less the
negatives.

The closest I got was using:
"(\D+(-)?\d+)"

but it pulls
"-8
instead of
-8

or
-8

instead of
-8


I'm just curious about what happened with my suggestion?

"[-+]?\b\d+\b"
--ron