Repeat Text upto given N then plot given text

Hello Friends

The text `AAA' need to plot upto the given N Number in Cell B2,

After the formula should plot `BBB' upto last where we entered the formula.

thanks in advance

In D2 copied down

Formula:

Please Login or Register  to view this content.

D2=if(rows(d$2:d2)>b$2,"bbb","aaa")

Please Login or Register  to view this content.

try this and copy towards down

Hello Richard and Shiva

Thanks for your formulas, which is working well.

Thanks again

My pleasure and thanks for the rep.