Macro for detect palindromes and repeats in letters/numbers string

[Luciano Paulino da Silva]

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

 

[Luciano Paulino da Silva]

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]

You have multiple responses at your other threads.

 

[Luciano Paulino da Silva]

Thank you for your attention Dave.
However, to date we have no solution to the problem.
Thanks in advance,
Luciano

 

[Dave Peterson]

By multiposting your question to multiple newsgroups, it just means that your
answers are scattered. I know that lots of people won't take time answering
questions that may have been answered in a different forum. I think that it's
just a waste of time.

 

[Luciano Paulino da Silva]

Dear Dave Peterson,
I'm sorry about this. I'm not experient in such newsgroups.
Excuse me for this strange procedure.
Luciano