ExcelBanter - Help required

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help required (https://www.excelbanter.com/excel-discussion-misc-queries/42201-help-required.html)

Sanjeev

Help required

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

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

All times are GMT +1. The time now is 12:03 AM.