Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numbers of repeats of a string
Dear all,
I am looking to detect repeats (sequences of letters or numbers which are repeating at least twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected repeats could be listed bellow A3; and that the number of times that they appear in the sentence could be listed bellow cells B3, as the following small example: QGAGGAAGGAGQ 4 Repeats detected Number GA 3 AG 3 GAG 2 GG 2 Somebody could help me? Thanks in advance, Luciano |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
Macro for detect palindromes and repeats in letters/numbers string | Excel Worksheet Functions | |||
Macro for detect palindromes and repeats in letters/numbers string | New Users to Excel | |||
How can I count the number of times a letter repeats in a string? | Excel Worksheet Functions | |||
Column of Numbers in xls to String of Numbers in txt | Excel Discussion (Misc queries) |