How to Mirror Text in Excel (5 Easy Ways)

Looking for ways to know how to mirror text in Excel? Sometimes, we want to mirror the letters in a text in an Excel cell or text box. Here, you will find 5 ways to mirror text in Excel.


Download Practice Workbook


5 Ways to Mirror Text in Excel

Here, we have a dataset containing Name, Age, and Profession of some citizens. Now, we will use this dataset to show you how to mirror text in Excel going through some easy steps.

Ways to Mirror Text in Excel


1. Use of Combined Functions to Mirror Text in Excel

In the first method, we will use the LEN, INDIRECT, ROW, ABS, MID, and TEXTJOIN Functions to mirror text in Excel. We are using the MID function to get the starting point of the middle string and the TEXTJOIN function to add a list of string values and convert it into a single string value.

Here, we have a dataset containing some Name. Now we will use these text values to show you how to mirror text in Excel.

Use of Combined Functions to Mirror Text in Excel

Follow the steps given below to do it on your own dataset.

Steps:

  • Firstly, select Cell C5.
  • Then insert the following formula.
=TEXTJOIN("",1,MID(B5,ABS(ROW(INDIRECT("1:"&LEN(B5)))-(LEN(B5)+1)),1))

Formula Breakdown

  • LEN(B5)—–> The LEN function returns the length of a text.
    • Output: {5}
  • ROW(INDIRECT(“1:”&LEN(B5)))—–>The ROW function returns the row number of a given Cell.
    • ROW(INDIRECT(“1:”&5))—–> turns into
      • Output: {1;2;3;4;5}
  • ABS(ROW(INDIRECT(“1:”&LEN(B5)))-(LEN(B5)+1))—–> The ABS function returns the absolute value of a number.
    • ABS({1;2;3;4;5}-(5+1))—–> becomes
      • Output: {5;4;3;2;1}
  • MID(B5,ABS(ROW(INDIRECT(“1:”&LEN(B5)))-(LEN(B5)+1)),1)—–> The MID function returns a number of strings from a given middle string.
    • MID(B5,{5;4;3;2;1},1)—–> turns into
      • Output: {“y”;”l”;”i”;”m”;”E”}
  • TEXTJOIN(“”,1,MID(B5,ABS(ROW(INDIRECT(“1:”&LEN(B5)))-(LEN(B5)+1)),1))—–> The TEXTJOIN function returns the joined string value.
    • TEXTJOIN(“”,1,{“y”;”l”;”i”;”m”;”E”})—–> turns into
      • Output: {ylimE}
  • After that, press ENTER to get the value of Mirror Text.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Use of Combined Functions to Mirror Text in Excel

  • Finally, you will get all the Mirror Text values.


2. Using CONCATENATE and TRANSPOSE Functions to Mirror Text

We can also mirror text using the CONCATENATE and TRANSPOSE functions in Excel. The CONCATENATE function is used to join text values. On the other hand, the TRANSPOSE function is used to modify the orientation of a range. Here, we will use this function to change the orientation of a range from column to row.

Using CONCATENATE and TRANSPOSE Functions to Mirror Text

Go through the steps given below to do it on your own.

Steps:

  • In the beginning, select Cell C5.
  • After that, insert the following formula.
=MID($C$4,LEN($C$4)-ROW(C1)+1,1)

Formula Breakdown

  • LEN($C$4)—–> The LEN function returns the length of a text.
    • Output: {5}
  • ROW(C1)—–> The ROW function returns the row number of a given Cell.
    • Output: {1}
  • MID($C$4,LEN($C$4)-ROW(C1)+1,1)—–> The MID function returns a number of strings from a given middle string.
    • MID($C$4,5-{1}+1,1)—–> turns into
      • Output: {“y”}
  • Next, press ENTER to get the last letter.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Using CONCATENATE and TRANSPOSE Functions to Mirror Text

  • Now, you will get all the letters of the text in mirror form.

  • After that, select Cell C11.
  • Then, insert the following formula.
=TRANSPOSE(C5:C9)

Using CONCATENATE and TRANSPOSE Functions to Mirror Text

Here, in the TRANSPOSE function, we inserted Cell range C5:C9 as the array.

  • Next, you will get the letters in a modified orientation.

  • After that, select Cell C12.
  • Then, insert the following formula.
=CONCATENATE(C11,D11,E11,F11,G11)

Using CONCATENATE and TRANSPOSE Functions to Mirror Text

Here, we joined the letters in Cell C11, Cell D1, Cell E1, Cell F1, and Cell G1 using the CONCATENATE function to get the mirror text.

  • Finally, you will get the Mirror Text.

Read More: How to Mirror Cells with Formula in Excel (3 Simple Ways)


3. Applying VBA to Mirror Text in Excel

In the third method, we will show you how to mirror text by applying VBA in Excel. Follow the steps given below to do it on your own.

Steps:

  • Firstly, go to the Developer tab >> select Visual Basic.

Applying VBA to Mirror Text in Excel

  • Now, Microsoft Visual Basic for Application box will open.
  • After that, click on Insert >> select Module.

  • Then, write the following code in your Module.
Sub Mirror_Text()
Dim Name As Range
Dim Cell_Value As Range
Set Name = Application.Selection
For Each Cell_Value In Name
    Cell_Value.Offset(0, 1).Value = StrReverse(Cell_Value)
Next Cell_Value
End Sub

Applying VBA to Mirror Text in Excel

Code Breakdown

  • Firstly, we created a Sub Procedure as Mirror_Text.
  • Then, we declared Name and Cell_Value as Range.
  • Now, we set the Name range as Application Selection.
  • After that, we used a For Each loop for each Cell_Value in Name where we reversed the Cell_Value using StrReverse method and assigned it to the Offset (0,1) Cell.
  • Then, we set Cell_Value as Next.
  • Next, click on the Save button and go back to your worksheet.

  • First, select the cell range. Here, I selected the range B5:B11.
  • Then,  go to the Developer tab >> click on Macros.

Applying VBA to Mirror Text in Excel

  • Now, the Macros box will appear.
  • Next, select Mirror Text.
  • After that, click on Run.

  • Finally, you will get all the Mirror Text values.

Applying VBA to Mirror Text in Excel

Read More: How to Mirror Data in Excel (3 Easy Ways)


4. Applying User Defined Function to Mirror Text in Excel

Using a User Defined Function we can create a function on our own using Excel VBA and can call that function later on to execute a task. Now, we will show you how to mirror text using the User Defined Function in Excel Cell.

Steps:

  • In the beginning, go to the Developer tab >> select Visual Basic.

Applying User Defined Function to Mirror Text in Excel

  • Then, insert a module going through the step shown in Method 3.
  • After that, write the following code in your Module.
Function Mirror(Name As String) As String
    Mirror = StrReverse(Trim(Name))
End Function

Code Breakdown

  • Firstly, we created a function named Mirror and then used Name as String.
  • Then, we used the Trim and StrReverse VBA functions on Name and kept the values in Mirror.
  • Finally, we ended the function.
  • After that, Save the code by following the step shown of Method 3.
  • Now, select Cell C5.
  • Next, insert the following formula.
=Mirror(B5)

Applying User Defined Function to Mirror Text in Excel

Here, we used the Used Defined function Mirror that we created using VBA and inserted Cell B5 as the input to get Mirror Text.

  • After that, press ENTER to get the Mirror Text.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get all the Mirror Text values.

Applying User Defined Function to Mirror Text in Excel

Read More: How to Stop Cell Mirroring in Excel (5 Easy Ways)


5. Using Format Shape Feature to Mirror Text in Text Box

In the final method, we will show you how to mirror text in a Text Box using the Format Shape feature.

Here, we have a Text Box containing a Text as Personal Information. Now, we will show you how you can mirror this text using the Format Shape feature.

Using Format Shape Feature to Mirror Text in Text Box

Follow the steps given below to do it on your own.

Steps:

  • Firstly, select the Text Box and Right-click on it.

  • Then, select Format Shape.

Using Format Shape Feature to Mirror Text in Text Box

  • Now, the Format Shape box will appear.
  • After that, click on the pentagon icon.
  • Next, click on 3-D Rotation.
  • Then, insert 180 as X Rotation and Y Rotation.

  • Finally, you will get the text in the Text Box in the Mirror version.

Using Format Shape Feature to Mirror Text in Text Box

Read More: How to Mirror Image in Excel (2 Easy Methods)


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 5 ways to mirror text in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo