Isn't Frank's suggestion a little shorter and easier?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"ramsdesk" wrote in message
...

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