Flipping row data vertically!!

[export.consultants]

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

 

[Gord Dibben]

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