Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

How Can I Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in the spreadsheet of libre office CALC? For example: I may have in cells A1:A4 the alphanumeric string: A,B,C,D

I want to repeat that sequence in cells e.g. B1:B40 so many times. How is this possible?

A1: A    B1: A
A2: B    B2: B
A3: C    B3: C
A4: D    B4: D
         B5: A
         B6: B
         B7: C
         B8: D
         B9: A
         B10: B
         B11: C
         B12: D
         B..: ...
         B37: A
         B38: B
         B39: C
         B40: D