Reverse data!

[VIANEY]

I HAVE A FILE CONTAINING OVER 2MILLION ACCOUNT NUMBERS.
I NEED THESE ACCOUNT NUMBERS TO READ BACKWARDS IN
A SEPARATE COLUMN.

FOR EXAMPLE:

A1 DATA : 1234
SHOULD READ IN B1 AS
4321

I'VE TRIED USING =TEXTREVERSE(A1)
BUT IT IS NOT WORKING COULD SOMEONE PLEASE HELP ME
WHAT AM I MISSING

THANK YOU IN ADVANCE FOR ANYONE WHO CAN HELP ME!

 

[Asala42]

I haven't heard of that function, but you could create a UDF for this purpose.
So if you are in 2010, this will need to be an *xlsm file to use this solution.

- Hit Alt+F11
- In VBA, hit Insert>Module
- enter this code:

Function ReverseText(Text) As String

Dim TextLeng, i As Long
TextLeng = Len(Text)

For i = TextLeng To 1 Step -1
ReverseText = ReverseText & Mid(Text, i, 1)
Next i

End Function

Now you can use this as a function. As in:
=ReverseText(A1)

 

[VIANEY]

thank you so much for your quick response!
I will try this

 

[Armando Montes]

One mores UDF:

Function Mirror(s As String)
    Mirror= StrReverse(s)
End Function

=Mirror(A1)