Invert Text

[Guest]

Is there an easy way to invert text? For example, if A1 = "Blanche DuBois"
I would like invert(A1) to equal "sioBuD ehcnalB"

Thanks in advance

 

[David McRitchie]

You can use StrReverse in a User Defined Function, or in a macro
http://groups.google.com/groups?threadm=#52e1e#[email protected]

Function ReverseText(cell)
ReverseText = StrReverse(cell.Text)
End Function

usage:
=ReverseText(A1)

 

[Guest]

Thank you. Works like a charm!