One method...........a UDF
Public Function RevStr(rng As Range)
RevStr = StrReverse(rng.text)
End Function
=RevStr(cellref)
If you want a number to remain a number.............
=RevStr(cellref)*1
Gord Dibben MS Excel MVP
On 1 Mar 2007 15:37:56 -0800,
wrote:
Hi all,
I need to do following in excel.
column data
123456
789123
what I want is
654321
321987
Any help is highly appreciated.
C