How to Reverse a string in Microsoft Excel ?

There are times when you might want to reverse a string or text in a cell in Excel to achieve some objectives. Well, there are NO direct or built-in function to achieve this but one could create a User Defined Function using VBA and call the same via the formula.

How to Reverse a string in Microsoft Excel ?

1. Press the keyboard shortcut key ALT + F11 to display the Microsoft Visual Basic for Applications dialog.

2. In the “Microsoft Visual Basic for Applications” dialog , Click Insert –> Module and then enter the following code in to the editor.

Function Reverse(str As String) As String
    Reverse = StrReverse(Trim(str))
End Function

3. Save the changes and then close the “Microsoft Visual Basic for Applications” dialog.

4. Navigate back to the worksheet where you want to display the reverse of a string and enter the following formula and specify the cell for which you need to find the reverse of the string.

image

Leave a Reply