{"id":12195,"date":"2014-05-06T12:44:57","date_gmt":"2014-05-06T12:44:57","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=3651"},"modified":"2022-09-13T19:40:13","modified_gmt":"2022-09-13T19:40:13","slug":"excel-formula-to-reverse-a-string-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/","title":{"rendered":"Custom Formula to Reverse a String in Excel"},"content":{"rendered":"

Dear Friends,<\/p>\n

\nThis is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that built-in function you can create your own custom formula to reverse a string.\n<\/p>\n

Following is the code to reverse a string in VBA function which needs to pasted in your Workbook Module. To know the procedure of creating a User Defined Function in Excel read this Article How to create Custom Formulas in Excel<\/a><\/strong>\n<\/p>\n

VBA Code for creating your Custom Formula to reverse a string in Excel Sheet<\/h3>\n
\r\n'Custom Function to reverse a string\r\nPublic Function strReverse(ByVal cell As Range) As String\r\n    strReverse = VBA.strReverse(cell.Value)\r\nEnd Function\r\n<\/code><\/pre>\n

Cell Address goes as Input in the above formula. It will read the value stored in that cell and display the reverse of that string in the cell where Formula is typed. Refer the below image.<\/h3>\n

 
\n\"Custom
\n <\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear Friends, This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that built-in function you can create […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673,1246,1676],"tags":[],"class_list":["post-12195","post","type-post","status-publish","format-standard","hentry","category-excel-formula","category-excel-functions","category-macro","category-excel-tips"],"yoast_head":"\nCustom Formula to Reverse a String in Excel - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Custom Formula to Reverse a String in Excel\" \/>\n<meta property=\"og:description\" content=\"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-06T12:44:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-13T19:40:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Custom Formula to Reverse a String in Excel\",\"datePublished\":\"2014-05-06T12:44:57+00:00\",\"dateModified\":\"2022-09-13T19:40:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\"},\"wordCount\":164,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp\",\"articleSection\":[\"Excel Formula\",\"Excel Functions\",\"Excel Macro\",\"Excel Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\",\"name\":\"Custom Formula to Reverse a String in Excel - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp\",\"datePublished\":\"2014-05-06T12:44:57+00:00\",\"dateModified\":\"2022-09-13T19:40:13+00:00\",\"description\":\"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Custom Formula to Reverse a String in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Custom Formula to Reverse a String in Excel - Let's excel in Excel","description":"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Custom Formula to Reverse a String in Excel","og_description":"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string","og_url":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-05-06T12:44:57+00:00","article_modified_time":"2022-09-13T19:40:13+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Custom Formula to Reverse a String in Excel","datePublished":"2014-05-06T12:44:57+00:00","dateModified":"2022-09-13T19:40:13+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/"},"wordCount":164,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp","articleSection":["Excel Formula","Excel Functions","Excel Macro","Excel Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/","name":"Custom Formula to Reverse a String in Excel - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp","datePublished":"2014-05-06T12:44:57+00:00","dateModified":"2022-09-13T19:40:13+00:00","description":"Excel formula to reverse a String | Custom formula to reverse a string | User defined function to reverse a string | UDF to reverse a string","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/Custom-Formula-To-Reverse-String.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-formula-to-reverse-a-string-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"Custom Formula to Reverse a String in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12195"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12195"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12195\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}