Try

=TRUNC(SUBSTITUTE(A1,"USD",""))


--

Regards,

Peo Sjoblom


"austi82110" wrote
in message ...

Hi,

Anyones suggestions on this would be greatly appreciated.

I have a dataset that is in this format

997.46 USD
89.87 USD
3966.40 USD

I need to get an output from excel in another column that has

997
89
3966

I believe i should be using a combinations of the LEN and FIND
functions, but I have been unsuccessful. Any Ideas? Thanks:)


--
austi82110
------------------------------------------------------------------------
austi82110's Profile:
http://www.excelforum.com/member.php...o&userid=30080
View this thread: http://www.excelforum.com/showthread...hreadid=497607