-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to reverse a character string?
- Thread starter glorber
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
One option is to invoke REVERSETEXT() from the free morefunc.xll add-in.
Upvote
0
sykes
Well-known Member
- Joined
- May 1, 2002
- Messages
- 1,885
- Office Version
- 365
- Platform
- Windows
.......or for a VBA solution, if the text string's in A1, and you wanted the result in B1, run this code from the WORKSHEET'S MODULE........
Code:
Sub invert_string()
Dim str_len As Long
Dim str As String
str_len = Len(Me.Range("A1"))
For str_len = str_len To 1 Step -1
str = str & Mid(Me.Range("A1"), str_len, 1)
Next str_len
Me.Range("B1").Value = str
End Sub
Upvote
0
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
This is an example of the result that I get:
<b>Jackson</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:114px;" /><col style="width:106px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td >Fred Smith</td><td >htimS derF</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=backward(A1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4
<b>Jackson</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:114px;" /><col style="width:106px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td >Fred Smith</td><td >htimS derF</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=backward(A1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4
Upvote
0
Similar threads
- Solved
