Hi Sanjeev,

I want to know if it is possible through any function in excel. Eg:-

COL.1 COL.2 COL.3(Answer required)

A 2 AA
B 4 BBBB
C 1 C
D 5 DDDDD


Use:

=REPT(A1,B1)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com