Macro for detect palindromes and repeats in letters/numbersstring
Thank you for your attention Dave.
However, to date we have no solution to the problem.
Thanks in advance,
Luciano
On 14 abr, 14:13, Dave Peterson wrote:
You have multiple responses at your other threads.
Luciano Paulino da Silva wrote:
On 14 abr, 11:58, Luciano Paulino da Silva
wrote:
Dear all,
I am looking to detect palindromes (sentence or number or other
sequence of units that can be read the same way in either direction)
and repeats (sequences of letters or numbers
which are repeating atleast 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 palindromes and repeats could be listed bellow A2
and C2, respectively; and that the number
of times that they appear in the sentence could be listed bellow cells
B2 and D2, respectively, as the following small example:
QGAGGAAGGAGQ
Palindromes * * Number * * * * *Repeats * * * * Number
QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3
GAG * * * * * * 2 * * * * * * * AG * * * * * * *3
GG * * * * * * *2 * * * * * * * GAG * * * * * * 2
AA * * * * * * *1 * * * * * * * AA * * * * * * *1
* * * * * * * * * * * * * * * * GG * * * * * * *2
Somebody could help me?
Thanks in advance,
Luciano
Correction:
QGAGGAAGGAGQ
Palindromes * * Number * * * * *Repeats * * * * Number
QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3
GGAAGG * * * * *1 * * * * * * * GG * * * * * * *2
GAAG * * * * * *1 * * * * * * * AG * * * * * * *3
GAG * * * * * * 2 * * * * * * * GAG * * * * * * 2
GG * * * * * * *2
AA * * * * * * *1
--
Dave Peterson
|