software

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

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, quot; quot;)
s = quot;quot;
For i = UBound(v) To LBound(v) Step -1
s = s amp; v(i) amp; quot; quot;
Next i
MirrorStr = Trim(s)
End Functionquot;PDquot; wrote:

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