Forum Discussion

Copper Contributor

May 03, 2022

Reverse numbers

Hi. Looking for help with the excel formula that will reverse my numbers. Ex. I type in 558 and I need it to show 855 in a separate cell.

Thanks in advance

4 Replies

mtarler
Silver Contributor
May 04, 2022
try this =CONCAT(MID(A1,SEQUENCE(LEN(A1),1,LEN(A1),-1),1))
- Queen_Bee
  Copper Contributor
  May 04, 2022
  Thank you so much
Detlef_Lewin
Silver Contributor
May 04, 2022
Queen_Bee
Why didn't you ask Google?
=--CONCAT(MID(A1,SEQUENCE(LEN(A1),,LEN(A1),-1),1))
- Queen_Bee
  Copper Contributor
  May 04, 2022
  I did. What I found didn't work. Thanks!

Resources