Multiplying text into cells

Hi,

I need to multiply the text in a cell by another cell which is a number, then it will give me the same text in the next cells across by that number.

eg, the word 'apple' is in the first cell (A1). then I type 7 in the next cell (A2), which will generate the word apple in the next 7 cells across (A3-A9)
the word 'banana' is in the next row down in cell (B1). then I type 4 in the next cell (B2), which will generate the word banana in the next 4 cells across (B3-B6) etc etc

Hope this makes sense.

Thanks.

Perfect,


Thanks Glenn.