Mirror columns or text

[Guest]

If I have a phrase in a column for example academy of music philadelphia,
how do I mirror that text to read philadelphia music of academy. Can I
rotate the text then mirror it? Any suggestions please let me know. Mirror
is the key here but I have no Idea how to do it.

Academy of music philadelphia
philadelphia music of academy

 

[Guest]

This a UDF to mirror string:

use like normal function:

in b1

=MirrorStr(A1)

where A1 contains string

HTH

Function MirrorStr(ByVal rStr As String)
Dim v As Variant
v = Split(rStr, " ")
s = ""
For i = UBound(v) To LBound(v) Step -1
s = s & v(i) & " "
Next i
MirrorStr = Trim(s)
End Function