gibt es eine Formel, die mir die Buchstabenreihenfolge:
ACGTACGTACGT spiegelverkehrt darstellt wie:
TGCATGCATGCA ?
Ich erbitte Antworten unter meiner Email Adresse: imetzger@gmx.de
Viele Grüße
Ingo Metzger
Function Rueck(rng As Range) As String
Rueck = StrReverse(rng)
End Function
Function rev_text(myC As Range) As String
Dim i As Integer
Dim tmpStr As String
tmpStr = ""
For i = Len(myC.Text) To 1 Step -1
tmpStr = tmpStr & Mid(myC.Text, i, 1)
Next i
rev_text = tmpStr
End Function
Datei | ||||||||||||||||||
| ||||||||||||||||||
Function Umdrehen(rng As Range) As String
Dim iCount As Integer
For iCount = Len(rng) To 1 Step -1
Umdrehen = Umdrehen & Mid(rng, iCount, 1)
Next
End Function