Help required

Sanjeev · Aug 25, 2005

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

Thanks in advance for your help
Sanjeev

Jan Karel Pieterse · Aug 25, 2005

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