Duplicating cell content x times

[sdugar]

i need to copy a word x times in a spreadsheet (these are search terms that I am trying to duplicate to generate a cloud tag - so need to capture not just the word by also the frequency it occurring at. Is there an excel formula I can use to do this?

My data looks something like this:
Buy shoes (search term), 4300 (number of times this term occurs)
Boots (search term), 1000 (number of times this term occurs)
Thanks

 

[ravishankar]

HI
it is not clear whether you wish to copy the search term 4800 times or count the number of times the search term occurs. is the search term a substring?
Ravi

 

[sdugar]

I need to copy the search term 4800 times. So an automated way of turning "shoes" into "shoes shoes shoes shoes shoes ....."

Thanks

 

[JackDanIce]

=REPT(A1,4800)

adjust if need be, e.g.

=REPT(A1&" ",4800)

 

[lenze]

Hi and welcome to the board!!!
Do you want "shoes shoes shoes shoes shoes ....." in One Cell? A Column? Where?

lenze

 

[sdugar]

it can be in one cell, or multiple columns, or multiple rows. I could just copy the block and paste in text.

Thanks
Smita

 

[JackDanIce]

Have you tried what I suggested? That would be the easiest way but limited to a single cell.

I think Lenze's suggestion of across rows or down columns would require a macro - depending on what you require!

 

[sdugar]

Thank you so much JackDanIce. Works like a dream.!!!