I’m struggling with a problem in Excel right now with some Amino Acid data.
The idea is that i would have a string of AA residues that need to be polymerized (functionally contatenated to themselves) a number of times based on a multiplier.
So, if I have a sequence AAGKLY, and I want to polymerize it 4 times, I should end up with AAGKLYAAGKLYAAGKLYAAGKLY.
Ideally, AAGKLY would be in a cell, the number 4 would be in a cell next to it, and my formula would spit out the full concatenation in the final cell.
Concatenate() seems to be my best bet, but I can’t use VBA to do any sort of While Loop. My other option seems to be a massive if statement, but then I have to worry about someone using this sheet to do something like a 50 times polymerization while I’ve only written up to 40 if statements. Is there a good way to leverage the concatenate function?
>Solution :
I believe that the REPT function is what you are looking for:
=REPT("ABC",4) => ABCABCABCABC