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 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.