How to Mirror Text in Excel (5 Easy Ways)

Looking for ways to learn 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.

How to Mirror Text in Excel: 5 Ways

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

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 Names. Now we will use these text values to show you how 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.

• 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.

• 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.

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.

• 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.

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

• After that, select Cell C11.
• Then, insert the following formula.

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.

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 Change Text Orientation in Excel

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.

• Now, the 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

• 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.

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

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

Read More: Difference Between Alignment and Orientation in Excel

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.

• 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

• After that, Save the code by following the steps shown in Method 3.
• Now, select Cell C5.
• Next, insert the following formula.

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.

Read More: How to Rotate Text by 180 Degrees in Excel

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.

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.

• 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.

Practice Section

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

Download Practice Workbook

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

• How to Change Orientation from Horizontal to Vertical in Excel
• How to Write Vertically in Excel
• How to Change Orientation of Text to 22 Degrees in Excel

<< Go Back to Rotate Text | Text Formatting | Learn Excel