Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell

Question

Currently, I'm having trouble with Excel with a situation involving some amino acid data.

The concept is that I would need to polymerize (functionally connect to themselves) a series of AA residues a certain number of times depending on a multiplier.

Hence, if I want to polymerize the sequence AAGKLY four times, the result should be AAGKLYAAGKLYAAGKLYAAGKLY.

AAGKLY and the number 4 should ideally be in separate cells, and my formula should output the entire concatenation in the last cell.

Concatenate() appears to be my best option, but I am unable to implement any kind of While Loop using VBA. The other alternative that seems feasible to me is a huge if statement, but that raises the possibility of someone utilising this sheet to perform, say, a polymerization 50 times when I've only written up to 40 if statements. Is it possible to effectively use the concatenate function?

Answer 1

Use the REPT function:

=REPT("ABC",4) => ABCABCABCABC