change text direction in excel

[parishi50]

How do you change text direction in excel?

 

[Mike H]

Try,

Format|Cell|Alignment

Mike

 

[Gord Dibben]

Versions earlier thab 2007

Format>Cells>Alignment>Orientation

This UDF will change abcd to dcba

Public Function RevStr(rng As Range)
RevStr = StrReverse(rng.text)
End Function

If "direction" means something else, post back.


Gord Dibben MS Excel MVP