Ask Your Question

estatistics's profile - activity

2018-08-26 20:14:59 +0100 received badge  Notable Question (source)
2018-08-26 14:38:39 +0100 marked best answer 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
2018-08-26 14:38:39 +0100 received badge  Scholar (source)
2018-08-26 14:30:26 +0100 commented answer Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

Thank you Impocta!

2018-08-26 13:53:26 +0100 received badge  Popular Question (source)
2018-08-26 13:32:17 +0100 commented answer Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

Thank you for your answer. It was really very helpful. However, if someone wants to not have an extra long, numerical co

2018-08-26 10:19:17 +0100 asked a question Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel How Can I Repeat a given alphanumeric sequ

2018-08-20 16:53:02 +0100 received badge  Supporter (source)
2018-08-18 14:33:19 +0100 asked a question Reset shortcut keys for Calc

Reset shortcut keys for Calc Hello Libreoffice users, Thank you for your valuable help in the past. I Have a new problem

2016-03-11 23:47:56 +0100 received badge  Notable Question (source)
2016-03-11 23:47:56 +0100 received badge  Popular Question (source)
2015-12-24 01:06:41 +0100 commented question How do I insert named ranges in charts?

me too, it is not possible! :(

2015-12-22 21:07:10 +0100 received badge  Student (source)
2015-12-22 16:26:16 +0100 asked a question OpenOffice / LibreOfiice / Calc - When i am searching for partial text in a column, if text contains the character "?", no results are given!

OpenOffice / LibreOfiice / Calc - When i am searching for partial text in a column, if text contains the character "?", no results are given!

For Example: =IFERROR(INDEX($A$1:$A279;MATCH(IF(SEARCH($G$1;A80)=1;A80;"");$A$1:$A$200;0));"")

If $G$1 is "aaa" the search formula for text string "aaaaaaaarchg" will result 1 (positive)

HOWever if the text string is "aaaaaaaarchg?" will result 0 (negative).

(? can be anywhere inside the text string).