As long as the the numbers are grouped this will work

=--MID(A1,MATCH(FALSE,ISERROR(--MID(A1,ROW(INDIRECT("1:100")),1)),0),100-SUM(--ISERROR(--MID(A1,ROW(INDIRECT("1:100")),1))))

entered with ctrl + shift & enter
assuming that the first data starts in A1

if you have leading zeros remove the first 2 --


Regards,

Peo Sjoblom

"jeremy via OfficeKB.com" wrote:

The numbers are all sequential. The text/puctuation are before or after....
No pattern other than that...

--
Message posted via http://www.officekb.com