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.
Bookmarks