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