Channel: MrExcel.com

Category: Howto & Style

Tags: excelmrexcelhow to reverse text in excelsearch in reverse song about excelusing strreverse in excel vbatommy tutonedan mayohfinancial modeling world cupmicrosoft excelbill jelenlianna gerishconcat left right sequence len

Description: 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: fmworldcup.com/excel-as-esports/fmwc-open Tommy Tutone: tutone.com Tommy Tutone on Cameo: cameo.com/tommytutone Chicago White Sox Organist Nancy Faust on Cameo: cameo.com/played41 Dan Mayoh: fintega.com 867-5309/Jenny on YouTube: 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