Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making MIcrosoft Word type from Right to Left
Hello. If I have a long DNA sequence and I want to reverse it to read right
to left instead of it reading left to right, does anyone know how to do this the easy way without having to retype everything manually? For example, if I have: Abcdefghijklmnopqrstuvwxyz I want: zyxwvutsrqponmlkjihgfedcba Does anyone know the shortcut or the function? Thanks a lot. |
#2
|
|||
|
|||
No idea about Word, but if you have Excel then you can dump the string in
there and use the following function to reverse the string, then paste back into Word:- For recent versions of excel Function ReverseText(cell) ReverseText = StrReverse(cell.Text) End Function or if before Excel 2000 Function ReverseText1(cell) 'For prior to 2000 Dim TextLen As Integer Dim i As Integer TextLen = Len(cell) For i = TextLen To 1 Step -1 ReverseText = ReverseText & Mid(cell, i, 1) Next i End Function -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "SL" wrote in message ... Hello. If I have a long DNA sequence and I want to reverse it to read right to left instead of it reading left to right, does anyone know how to do this the easy way without having to retype everything manually? For example, if I have: Abcdefghijklmnopqrstuvwxyz I want: zyxwvutsrqponmlkjihgfedcba Does anyone know the shortcut or the function? Thanks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to type the letter Y in a cell and have the word Yes appea. | New Users to Excel | |||
Importing Microsoft Word File Names | Excel Worksheet Functions | |||
How do you add an Excel spread sheet to a Microsoft Word report? | Excel Worksheet Functions | |||
How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel | |||
how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) |