Flipping row data vertically!!

  • Thread starter Thread starter export.consultants
  • Start date Start date
E

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
 
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
 
Back
Top