How To Reverse Text Or Words In Excel

Reverse Text String Order In Excel

Excel Reverse Text Order

Reverse any text the way you want, reverse all characters of the text, or reverse the words in the text, or reverse the words separated by comma, or reverse words separated by carriage return, or reverse the words separated by specific separator. Dose for Excel‘s Reverse Text Order utility can save you time and effort reversing text on huge worksheets.

Click DOSE » Text » Reverse Text Order

How To Reverse Text Or Words In Excel

Reverse all characters of text

  1. For example, reverse all characters of a text of “Excel” into “lecxE”.
  2. Select range of cells that you want to reverse their text characters, and then check Nothing option.
  3. Then click Apply. You will see the result as shown in the below screenshot.
How To Reverse All Characters of Text In Excel

Reverse text separated by space

  1. For example, reverse text separated by space such like “MS Excel” into “Excel MS”.
  2. Select range of cells that you want to reverse their text, and then check Space option.
  3. Then click Apply. You will see the result as shown in the below screenshot.
How To Reverse Text Or Words Separated by Space In Excel

Reverse text separated by comma

  1. For example, reverse text separated by comma such like “word,excel,PowerPoint,access” into “access,PowerPoint,excel,word”.
  2. Select range of cells that you want to reverse their text, and then check Comma option.
  3. Then click Apply. You will see the result as shown in the below screenshot.
How To Reverse Text Or Words Separated by Comma In Excel

Reverse text separated by carriage return

  1. For example, reverse text separated by carriage return or new lines.
  2. Select range of cells that you want to reverse their text, and then check Carriage return option.
  3. Then click Apply. You will see the result as shown in the below screenshot.
How To Reverse Text Or Words Separated by Carriage Return In Excel


Reverse text separated by specific separator

  1. For example, reverse text separated by anything you want such like “/” will turn “Dose/for/Excel” into “Excel/for/Dose”.
  2. Select range of cells that you want to reverse their text, and then check Specify option, then fill the text box with the separator you want.
  3. Then click Apply. You will see the result as shown in the below screenshot.
How To Reverse Text Or Words Separated by Specific Separator In Excel

Demo


  1. Select the cell(s) containing the text you want to reverse.
  2. Click DOSE » Text » Reverse Text Order
  3. Click on “Apply” button.
  4. Watch in awe as your text is instantly reversed, saving you valuable time and effort!
  • Effortless: No need to learn complex formulas or functions. This means anyone can use it, regardless of their Excel expertise.
  • Fast: Reverse millions of Excel text cells in seconds, freeing up your time for more important tasks.
  • Versatile: Works with individual cells, ranges, and even entire columns. Ideal for handling any volume of text data.
  • Accurate: Delivers perfect results every time, ensuring the integrity of your spreadsheets.
  • Time-Saving: No more wasting time crafting and debugging formulas. Dose for Excel takes care of the heavy lifting for you.
  • Increased Efficiency: Streamline your workflow and get more done in less time.
  • Reduced Errors: Eliminate the risk of errors associated with manual formula creation.
  • Data analysts: Quickly process and analyze text data without the hassle of formulas.
  • Financial professionals: Reverse financial data for analysis and reporting with ease.
  • Marketers: Create mirror-image text effects for marketing materials.
  • Students and educators: Simplify complex data manipulation tasks for learning and teaching.
  • Anyone who works with text data in Excel: Save time and effort with Dose for Excel’s intuitive and efficient solution.
  • Dose for Excel offers a variety of other powerful features to boost your Excel productivity.
  • The add-in is compatible with Excel 2007 and later versions.
  • A free 45 days trial is available for download.

More Features:

Excel Count Chars

Count Chars In Excel Count chars in a cell or in a selected range of…


Scroll to Top