Reverse Order of Characters in a Cell with Functions in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstoreverseordero, kutools
Published: 2020-10-08 08:02:18

---
title: Reverse Order of Characters in a Cell with Functions in Excel Office 365!!
published: true
date: 2020-10-06 08:52:19 UTC
tags: KutoolsExcelTutorial,StepstoReverseOrdero,Kutools
canonical_url: https://geekexcel.com/reverse-order-of-characters-in-a-cell-with-functions-in-excel-office-365/
---

In this article, we are going to see the steps to **Reverse Order of Characters in a Cell with Functions in Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Steps to Reverse Order of Characters in a Cell:

To reverse the order of characters in a cell, do as below steps.

- Let’s consider the below example sentence in the **cell B2** , and we are going to reverse the order of characters.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-8.png)<figcaption id="caption-attachment-15244">Example</figcaption>

- You need to **select a blank cell** to display the result.
- On the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Text** option from the drop-down menu, and **select** the **REVERSETEXT** option.

![Select the REVERSETEXT option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-REVERSEORDER-option.png)<figcaption id="caption-attachment-15245">Select the REVERSETEXT option</figcaption>

- It will open the **Function Arguments dialog box.**
- **Txt box –** You need to specify the cell that you want to reverse the order of characters.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Function-Arguments-dialog-box-1.png)<figcaption id="caption-attachment-15246">Function Arguments dialog box</figcaption>

- Then, **click** the **OK** button to get the result in the selected cell.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-8.png)<figcaption id="caption-attachment-15247">Output</figcaption>

## **Reverse Name Order in a Cell with Given Separator:**

To reverse the name order in a cell with a given separator, do as follows.

- You can see the below screenshot which has the example data list that contains names and ages separated by a comma. We are going to reverse the name order of this list.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-6.png)<figcaption id="caption-attachment-15250">Example</figcaption>

- You need to **select a blank cell** to display the result.
- On the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Text** option from the drop-down menu, and **select** the **REVERSETEXT** option.

![Choose REVERSETEXT option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-7.png)<figcaption id="caption-attachment-15249">Choose REVERSETEXT option</figcaption>

- It will open the **Function Arguments dialog box.**
- **Txt box –** You need to specify the cell that you want to reverse the data.
- **Separator\_char**  **–**  **Enter** the **separator** of a comma.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-3.png)<figcaption id="caption-attachment-15251">Function Arguments dialog box</figcaption>

- **Click** the **OK** button.
- Now, you will see the name and ages are reversed by a comma.
- Then, you need to drag the first cell down to fill the remaining cells.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-3.png)<figcaption id="caption-attachment-15252">Output</figcaption>

## Verdict:

In this article, you can clearly understand the steps to **Reverse Order of Characters in a Cell with Functions in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Find and Fill Missing Numbers in a Sequence in Excel](https://geekexcel.com/find-and-fill-missing-numbers-in-sequence-in-excel-office-365/)
- [Calculate Age By Date of Birth in Excel](https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/)