Soz, there is no easy way to explain.

there is a code 12343

i am on a different page and i got a formula that gets that number and
it shows the price of that product.

The problem is that the formula is looking for 12343 but cant find it
because of the person who made the spread sheet pressed space bar like
2 times so it makes 12342-- with the - being just space.

I need something that will get rid of that space.


--
Mythikal
------------------------------------------------------------------------
Mythikal's Profile: http://www.excelforum.com/member.php...o&userid=36680
View this thread: http://www.excelforum.com/showthread...hreadid=564166