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.