Remove Currency
Alan M. Robertson
=VALUE(RIGHT(D3,LEN(D3)-FIND(" ",D3)))
or
This is my version.
=VALUE(SUBSTITUTE(D3,LEFT(D3,FIND(" ",D3)),""))
© Copyright
andrewsexceltips.net
All Rights Reserved.