Flipping row data vertically!!
 

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

Flipping row data vertically!!
 

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