You can also try this:
=CONCATENATE(REPT("XXXX-",3), RIGHT(B3,4))
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=552847