I did below and it worked.
=CONCATENATE("AB",<cell number)
Thanks for your replies.
--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread:
http://www.excelforum.com/showthread...hreadid=273074