CeeGee
By using a user defined function.
Public Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.text)
End Function
Usage is: =RevStr(cellref)
If the data is numeric...... =RevStr(cellref)*1 which forces it back to
numeric.
This function would be copied to a general module in your workbook.
If not familiar with macros and VBA, visit David McRitchie's website on
"getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime..........
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Gord Dibben Excel MVP