I have some files in which there is a column where there are string data like
column C
abc10po2x33
m20xpx12zo1
qw45x39x12
...etc
I'm trying to get the product of the 2nd and 3rd numeric values using a custom function.
I've tried
Wished results are(in bold):Please Login or Register to view this content.
66 i.e.(2*33)
12 i.e.(12*1)
468 i.e.(39*12)
...etc
But the code is not working, please help.
Also, how do I use this function in any of my excel file and not a particular file?
Bookmarks