Reverse the text strings within cells in Excel and Google Sheets

=TEXTJOIN("",TRUE,MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1))

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Reverse the text strings within cells in Excel

How to reverse the text strings within cells in Excel?
Reverse the text strings within cells in Excel

REVERSE THE TEXT STRINGS WITHIN CELLS — EXCEL FORMULA AND EXAMPLE

=TEXTJOIN("",TRUE,MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1))

💡 Only works Office 365 versions of Excel

Reverse the text strings within cells in Google Sheets

How to reverse the text strings within cells in Google Sheets?
Reverse the text strings within cells in Google Sheets

REVERSE THE TEXT STRINGS WITHIN CELLS — GOOGLE SHEETS FORMULA AND EXAMPLE

=JOIN("",ARRAYFORMULA(MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1)))