Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to reverse text in a cell in Excel and Google Sheets
Heads up: Excel and Google Sheets do this differently.
Excel
=MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1)Google Sheets
=ARRAYFORMULA(MID(A2,LEN(A2)-SEQUENCE(LEN(A2))+1,1))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your text in cell A2 of your worksheet.
- 2In cell B2, enter the formula provided for Excel or Google Sheets.
- 3Press Enter to see the reversed text appear in cell B2.
Tips
- Ensure that the cell reference in the formula matches the cell containing your text.
- This method works for single-line text. For multi-line text, consider splitting the text into lines first.
- If you encounter errors, double-check that the formula is correctly entered and that there are no hidden characters in your text.
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I reverse text in multiple cells at once?
Yes, you can copy the formula down to other cells to reverse text in multiple cells.
What if my text contains special characters?
The formula will reverse all characters, including spaces and punctuation, exactly as they appear in the cell.
Is there a limit to the length of text I can reverse?
While there is no strict limit, very long texts might cause performance issues in Excel or Google Sheets.