{"id":9353,"date":"2024-10-21T20:19:51","date_gmt":"2024-10-21T20:19:51","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=9353"},"modified":"2025-02-21T16:28:06","modified_gmt":"2025-02-21T16:28:06","slug":"the-right-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/the-right-function-in-excel\/","title":{"rendered":"How to use the RIGHT function in Excel?"},"content":{"rendered":"<p>The RIGHT function in Excel can extract a set number of characters from the right side. Using the RIGHT command in Excel, you can quickly and efficiently extract specific characters from the right side of a text string, making data manipulation tasks much more efficient.<\/p>\n<ul>\n<li><a href=\"#what-is-the-right-function-in-excel?-right-function-syntax.\"><strong>What is the RIGHT function in Excel? RIGHT function syntax.<\/strong><\/a><\/li>\n<li><a href=\"#how-to-use-the-right-function-in-excel?\"><strong>How to use the RIGHT function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-get-a-substring-after-a-certain-character-in-excel?\"><strong>How to get a substring after a certain character in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-extract-a-substring-succeeding-a-delimiter?\"><strong>How to Extract a Substring Succeeding a Delimiter?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-force-the-excel-right-function-to-return-a-number?\"><strong>How to force the Excel RIGHT function to return a number?<\/strong><\/a><\/li>\n<li><a href=\"#reasons-why-the-right-function-cannot-be-used-on-dates?\"><strong>Reasons why the RIGHT function cannot be used on dates?<\/strong><\/a><\/li>\n<li><a href=\"#why-excel-right-function-not-working?\"><strong>Why Excel RIGHT function not working?<\/strong><\/a><\/li>\n<\/ul>\n<ol>\n<li>\n<h3><strong id=\"what-is-the-right-function-in-excel?-right-function-syntax.\"> What is the RIGHT function in Excel? RIGHT function syntax.<\/strong><\/h3>\n<\/li>\n<\/ol>\n<p>The RIGHT function in Excel is a text function that extracts a specified number of characters from the right side of a text string. It creates a substring with the rightmost characters of the specified text, permitting users to edit and retrieve relevant information from text data. The RIGHT function is often used in data processing tasks such as: For example, you can extract a file extension from a file name, get a last name from a full name, or get a specific identifier from code. Provides an easy way to manipulate text in Excel formulas, allowing users to efficiently manage and analyze text data.<\/p>\n<p>RIGHT function syntax<strong>: \u00a0=RIGHT(text, [num_chars])<\/strong><\/p>\n<p>Breakdown,<\/p>\n<p><strong>text:<\/strong> Required text string from which characters can be extracted.<\/p>\n<p><strong>num_chars:<\/strong><\/p>\n<ul>\n<li>Starting with the rightmost character, the number of characters to be extracted.<\/li>\n<li>By omitting num_chars, the final character of the string is returned as the default value.<\/li>\n<li>In case the total number of characters in a string is less than num_chars, then all strings are returned.<\/li>\n<li>#VALUE is returned by the Right expression when num_chars is negative.<\/li>\n<\/ul>\n<ol start=\"2\">\n<li>\n<h3><strong id=\"how-to-use-the-right-function-in-excel?\"> How to use the RIGHT function in Excel?<\/strong><\/h3>\n<\/li>\n<\/ol>\n<p><strong>Step 1:<\/strong> Take some names and their age, enter them into the table.<\/p>\n<p>Placed the data here.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-9354 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-1.jpg\" alt=\"the RIGHT function in Excel\" width=\"562\" height=\"294\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-1.jpg 562w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-1-300x157.jpg 300w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Add the column from C1:C7 to get the output there.<\/p>\n<p>A column has been selected.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9355 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-2.jpg\" alt=\"the RIGHT function in Excel\" width=\"675\" height=\"296\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-2.jpg 675w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-2-300x132.jpg 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Here you need to use the formula to get the function. The formula is: <strong>=RIGHT(A2)<\/strong><\/p>\n<p>Entered the formula here.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9356 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-3.jpg\" alt=\"the RIGHT function in Excel\" width=\"653\" height=\"286\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-3.jpg 653w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-3-300x131.jpg 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Now, press the enter button and you will get the output.<\/p>\n<p>Here is the result below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9357\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-4.jpg\" alt=\"RIGHT function\" width=\"672\" height=\"283\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-4.jpg 672w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-4-300x126.jpg 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Use the same formula from Step-3 or Drag-sown the cursor from C2.<\/p>\n<p>Here are all the RIGHT function results below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9358\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-5.jpg\" alt=\"RIGHT function\" width=\"707\" height=\"296\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-5.jpg 707w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-5-300x126.jpg 300w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/p>\n<ol start=\"3\">\n<li>\n<h3><strong id=\"how-to-get-a-substring-after-a-certain-character-in-excel?\"> How to get a substring after a certain character in Excel?<\/strong><\/h3>\n<\/li>\n<\/ol>\n<p><strong>Step 1:<\/strong> Take some names and enter the full names into your Excel as shown.<\/p>\n<p>Data has been placed here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9359\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-6.jpg\" alt=\"RIGHT function\" width=\"452\" height=\"240\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-6.jpg 452w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-6-300x159.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Add the column from B1:B5 to get a substring before a certain character there.<\/p>\n<p>A column has been placed here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9360\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-7.jpg\" alt=\"RIGHT function\" width=\"674\" height=\"232\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-7.jpg 674w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-7-300x103.jpg 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Enter the formula into your Excel as shown. To find out t a substring before a certain character, the formula will be: <strong>=RIGHT(A2,7)<\/strong><\/p>\n<p>Here, A2 is the column range and 7 is for how many alphabets the name contains.<\/p>\n<p>Here, Maxwell- it contains 7 characters.<\/p>\n<p>Used the formula here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9361\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-8.jpg\" alt=\"RIGHT function\" width=\"650\" height=\"220\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-8.jpg 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-8-300x102.jpg 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Now, Press enter and you will get the result.<\/p>\n<p>The result of substring after a certain character shows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9362\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-9.jpg\" alt=\"RIGHT function\" width=\"668\" height=\"230\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-9.jpg 668w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-9-300x103.jpg 300w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/p>\n<p><strong>\u00a0Step 5:<\/strong> Use the same formula from Step-3 and just change the column number and the number of characters in the name or Drag-sown the cursor from C2.<\/p>\n<p>Here are all the outputs below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9363\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-10.jpg\" alt=\"RIGHT function\" width=\"617\" height=\"225\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-10.jpg 617w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-10-300x109.jpg 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/p>\n<ol start=\"4\">\n<li>\n<h3><strong id=\"how-to-extract-a-substring-succeeding-a-delimiter?\"> How to Extract Substring Succeeding a Delimiter?<\/strong><\/h3>\n<\/li>\n<\/ol>\n<p><strong>Step 1:<\/strong> Create a table with some codes as shown below.<\/p>\n<p>Created the table here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9364\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-11.jpg\" alt=\"RIGHT function\" width=\"492\" height=\"267\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-11.jpg 492w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-11-300x163.jpg 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Add a column from B2:B6.<\/p>\n<p>Added the column here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9365\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-12.jpg\" alt=\"RIGHT function\" width=\"670\" height=\"259\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-12.jpg 670w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-12-300x116.jpg 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Here is the Extract Substring Succeeding a Delimiter formula. The formula is: <strong>RIGHT(cell_reference,LEN(cell_reference)-SEARCH(\u201cDelimiter\u201d, cell_reference))<\/strong> or <strong>=RIGHT(A2,LEN(A2)-SEARCH(\u201c-\u201c,A2))<\/strong><\/p>\n<p>Entered the formula here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9366\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-13.jpg\" alt=\"RIGHT function\" width=\"832\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-13.jpg 832w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-13-300x92.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-13-768x236.jpg 768w\" sizes=\"(max-width: 832px) 100vw, 832px\" \/><\/p>\n<p><strong>Step 4:<\/strong> In the end, hit enter to get the Output.<\/p>\n<p>Here is the Output below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9367\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-14.jpg\" alt=\"RIGHT function\" width=\"668\" height=\"246\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-14.jpg 668w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-14-300x110.jpg 300w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/p>\n<p><strong>Step 5:<\/strong> Use the same formula from Step-3 Drag-sown the cursor from C2.<\/p>\n<p>Here are all the outputs below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9368\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-15.jpg\" alt=\"RIGHT function\" width=\"610\" height=\"259\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-15.jpg 610w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-15-300x127.jpg 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<ol start=\"5\">\n<li>\n<h3><strong id=\"how-to-force-the-excel-right-function-to-return-a-number?\"> How to force the Excel RIGHT function to return a number?<\/strong><\/h3>\n<\/li>\n<\/ol>\n<p><strong>Step 1:<\/strong> Here is working with the above example data.<\/p>\n<p>Placed all the information into the table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9369\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-16.jpg\" alt=\"RIGHT function\" width=\"503\" height=\"302\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-16.jpg 503w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-16-300x180.jpg 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Now add another column from B1:B7 to get the result there.<\/p>\n<p>Added another column here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9370\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-17.jpg\" alt=\"RIGHT function\" width=\"607\" height=\"296\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-17.jpg 607w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-17-300x146.jpg 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Now, use the formula. The formula will be: <strong>=VALUE(RIGHT(A2,2))<\/strong><\/p>\n<p>The formula has been placed according to its data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9371\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-18.jpg\" alt=\"RIGHT function\" width=\"667\" height=\"279\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-18.jpg 667w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-18-300x125.jpg 300w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Now, press the enter and get the result.<\/p>\n<p>Here is the result below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9372\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-19.jpg\" alt=\"RIGHT function\" width=\"598\" height=\"295\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-19.jpg 598w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-19-300x148.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p><strong>Step 5:<\/strong> To get the result of the rest of the ID\u2019s use this formula or drag-down the cursor from B2 to B7.<\/p>\n<p>All the ID numbers are here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9373\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-20.jpg\" alt=\"RIGHT function\" width=\"549\" height=\"294\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-20.jpg 549w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2024\/07\/RIGHT-function-20-300x161.jpg 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/p>\n<ol start=\"6\">\n<li>\n<h3><strong id=\"reasons-why-the-right-function-cannot-be-used-on-dates?\"> Reasons of the RIGHT function cannot be used on dates?<\/strong><\/h3>\n<\/li>\n<\/ol>\n<ul>\n<li>In Excel, the RIGHT method is exclusively intended for handling text strings, not dates. Although Excel stores dates as serial numbers and can be manipulated with various date-related functions, the RIGHT function is not intended to interpret dates directly.<\/li>\n<li>Despite this, a date can be converted to a text string using TEXT or other formatting functions, and then the RIGHT function is applied to the result. This method is not required for conversion.<\/li>\n<li>When converted a date can be to a text string using TEXT, the RIGHT function then extracts the last two characters from this text string, which in this case represents the year. When working with dates in Excel, be aware that you need to take into account date formatting, regional settings, and possible errors caused by incorrect date representation.<\/li>\n<\/ul>\n<ol start=\"7\">\n<li><strong id=\"why-excel-right-function-not-working?\"> Why Excel RIGHT function not working?<\/strong><\/li>\n<\/ol>\n<p>If the right formula isn&#8217;t working correctly in your worksheet, it might be for one of the following reasons:<\/p>\n<ol>\n<li>The original data contains one or more spaces at the end. Extra spaces can be easily eliminated in Excel using the TRIM function or Trim Spaces tool.<\/li>\n<li>Argument &#8216;num_chars&#8217; is less than zero. Of course, you rarely intentionally insert negative numbers into a formula, but if the num_chars argument is calculated by another Excel function or a combination of various functions, and the Right formula returns #VALUE! then the error If this happens, be sure to check your nested functions for errors.<\/li>\n<li>A date is the initial value. The RIGHT function&#8217;s inability to handle dates.<\/li>\n<\/ol>\n<p><strong>You may be interested:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noreferrer noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noreferrer noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noreferrer noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noreferrer noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The RIGHT function in Excel can extract a set number of characters from the right side. Using the RIGHT command in Excel, you can quickly and efficiently extract specific characters from the right side of a text string, making data manipulation tasks much more efficient. What is the RIGHT function in Excel? RIGHT function syntax. &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/the-right-function-in-excel\/\"> <span class=\"screen-reader-text\">How to use the RIGHT function in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[952],"tags":[],"class_list":["post-9353","post","type-post","status-publish","format-standard","hentry","category-the-right-function-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=9353"}],"version-history":[{"count":4,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9353\/revisions"}],"predecessor-version":[{"id":9583,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9353\/revisions\/9583"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=9353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=9353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=9353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}