How can you reverse text in Excel? There is not a REVERSE function. You’ve recently seen me do this with a VBA loop. Lianna Gerrish from the Financial Modeling World Cup Semi-Finals would flip it and reverse it with strREVERSE in VBA.
Dan Mayoh and Jose Carlos Canejo both sent in a way to do it with native Excel functions. But… how do you ever remember CONCAT, LEFT, RIGHT, SEQUENCE, LEN?
In a special guest appearance on the 40th anniversary of the release of 867-5309 (Jenny), the lead singer of Tommy Tutone joins us with a song from his upcoming album – Music for Fellow Nerds. Listen to “Search in Reverse” a few hundred times and you will have it down!
Also in this episode:
Bill’s secret skill to say the alphabet backwards.
One of the two post-it notes on Bill’s cube wall from 1991-1999 reveals why he still uses VLOOKUP instead of Index and Match.
Many thanks to Tommy Tutone for having a great sense of humor and going along with my insane request.
Links
To enter the Financial Modelling World Cup: https://www.fmworldcup.com/excel-as-esports/fmwc-open/
Tommy Tutone: http://tutone.com/
Tommy Tutone on Cameo: https://www.cameo.com/tommytutone
Chicago White Sox Organist Nancy Faust on Cameo: https://www.cameo.com/played41
Dan Mayoh: http://fintega.com/
867-5309/Jenny on YouTube: https://www.youtube.com/watch?v=6WTdTwcmxyo
Table of Contents
(0:00) Finding text that is backwards
(0:40) Reverse Excel text using strReverse from Lianna Gerish
(1:06) Dan Mayoh schooling me on native functions
(1:38) Index/Match post-it note
(1:56) Saying the alphabet backwards
(2:15) 40-years ago, 867-5309 (Jenny) was released
(2:52) Tommy Tutone sings Search in Reverse
(3:57) How the search in reverse function works
(4:48) Wishing for =REVERSE
(4:59) Hire Tommy Tutone on Cameo