I have Excel 2000. I would like to get a Regexp function. I have model
numbers that I want to sort. Model numbers are composed of a prefix (variable
length), the model number (2-6 digits), and a suffix (variable length). The
left, right and mid functions only work if the prefix is a fixed length, thus
I need regexp to pick out the first group of 2-6 digits in a row, then sort
on that.

SO if I had a function that would look at column A (with the whole model #)
and put the modified, sortable model number in col B, that would be great.

Example model #s and extracted sort key:
W2424 2424
W2424P 2424
W3D2412 2412
W1836PLR 1836
DW362424L 362424
W3D1560DTL 1560

Thanks!

--
Sig: Say no to fixed width HTML tables. They look terrible in most browsers.