Hi all,

I would like to know how to create a VBA that can do the above.

Here is an example:

The data before extract is "a=1,995.000 b=2,001.000 c=1,994.000 d=1,996.000 e=1,281".

Need to extract number only to each cell, 1995 to column 1, 2001 to column 2 and so on.

Please check the attachment out.midmultiplecell.xlsx

Thank you.