I have made another post before Ron's last post. I have explained the
requirement with an example.

Regards,
Raj



On May 2, 1:43*am, Ron Rosenfeld wrote:
On Sat, 01 May 2010 21:08:01 +0200, Lars-Åke Aspelin
wrote:

Can't [\s\S] be replaced by . like this
(\d{15,16})(.*)

Lars-Åke

Your suggestion will work IF and ONLY IF there are no line feeds or carriage
returns in the cell. *In some flavors, there is an option to have Dot match
newline, but such does not exist in VBA (or Javascript).

If the OP, rather than wanting to extract everything to " ... the end of the
string in the cell" *only wanted to extract everything to the end of the line,
and ignore anything in the cell after a newline character, then (.*) would be
appropriate.
--ron