Assuming copied is required, the following 22 results were found.
function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way...
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...