So i have data in cell A1 of sheet 1 that is in this format:
I currenlty use the following formula to pull the 8.64% out of the cell:
This works fine, but i've created a macro that pulls all of my data instead of relying on links which always seem to get screwed up. Since in this instance, i need to copy the result of a formula instead of just raw data, i've become stuck. Any ideas?
HTML:
41,477,729.68 (8.64%)
I currenlty use the following formula to pull the 8.64% out of the cell:
HTML:
=-right(a1,8)
This works fine, but i've created a macro that pulls all of my data instead of relying on links which always seem to get screwed up. Since in this instance, i need to copy the result of a formula instead of just raw data, i've become stuck. Any ideas?