What might T2 contain? Is it just a single letter? What do you want t
return if T2 is blank?

Possibly

=T2&"00"

if T2 contains only one lette

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=50955