regex: include split "0=" like "a=" into .pattern

Hi all,

Currently I have this data,
a=1,995.000 b=2,001.000 c=1,994.000 d=1,996.000 e=1,281
using this code below to split into
1995, 2001, 1994, 1996, 1281.

Please Login or Register  to view this content.

To test the code, place data in K10.

However, there are non-standard data like,
0=1,995.000 b=2,001.000 c=1,994.000 d=1,996.000 e=1,281
will splited into
0, 1995, 2001, 1994, 1996, 1281.
Because there is "0=" in the data.

I would like to include code for excluding "0=" into .pattern.

Thank you.

http://www.mrexcel.com/forum/excel-q...ml#post3924809