It would be useful to have some example code, or example workbook to base this on, but you should be able to use "Mid" you just need to work out what positions you want to extract.
cGys1 (219.85) cGys2 (109.92) cGys3 (54.96) cGys4 (32.98) cGys5 (10.99)
Ok, so we have 5 numbers we want to extract.
How do YOU know which numbers they are? - Each number enclosed within brackets.
Excel can do the same thing using the InStr function, which will look for one string within another starting at a particular position in the string (optional)
So something like this, where text_line is your line of text as quoted above:
I've commented the code so that hopefully you can see how to adjust it to fit your macro, but if you have any questions please do ask
Bookmarks