Need help to extract numbers after specific text with two conditions. eg:-
1. 'EnWave reports Q3 EPS ($0.02) vs. (C$0.01) last year': in this case I need to extract the number coming after the text 'EPS' with brackets or shows as negative value, ie, as either (0.02) or -0.02.
2. 'EnWave reports Q3 EPS 56c vs. 80c last year': In the case when a letter 'C' comes after number, I need to divide it by 100 and shows as 0.56.
I prefer to do it as excel formula rather than VBA, since I am not good at it.
Thanks in advance!