hmmmm ok

how about if it was aaa-41-US

I would like to find aaa-41

I have played around with a nested IF(replace) statement, but I have to
know the placement

could I create a IF (find (replace) or am I over confusing this?

thanks
D


--
edmos1
------------------------------------------------------------------------
edmos1's Profile: http://www.excelforum.com/member.php...o&userid=31903
View this thread: http://www.excelforum.com/showthread...hreadid=516304