View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Help with Regexp, please

On Sat, 1 May 2010 05:39:32 -0700 (PDT), Raj wrote:

Hi,

The regular expression (\d{15,16}) matches a substring in a cell. I
want to extract the remaining part of the cell ie. from the character
after the matched substring till the end of the string in the cell
using a regular expression.

Is it possible to do this?

Thanks in advance for the help.

Regards,
Raj


(\d{15,16})([\s\S]*)

will capture everything in the cell and after your "match" into Group 2




--ron