{"id":863,"date":"2019-07-28T15:57:59","date_gmt":"2019-07-28T15:57:59","guid":{"rendered":"https:\/\/www.excelandmacros.com\/?p=863"},"modified":"2022-12-14T21:50:31","modified_gmt":"2022-12-14T21:50:31","slug":"use-len-function-to-provide-data-for-right-function","status":"publish","type":"post","link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/use-len-function-to-provide-data-for-right-function\/","title":{"rendered":"Use LEN function to provide data for RIGHT function"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"863\" class=\"elementor elementor-863\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-66280cea elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"66280cea\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1228f68a\" data-id=\"1228f68a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-60b17705 elementor-widget elementor-widget-text-editor\" data-id=\"60b17705\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>FORMULAS<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37e37ce1 elementor-widget elementor-widget-heading\" data-id=\"37e37ce1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Use LEN function to provide data for RIGHT function<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7b10113a elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"7b10113a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-28a81820\" data-id=\"28a81820\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7da02307 elementor-widget elementor-widget-sidebar\" data-id=\"7da02307\" data-element_type=\"widget\" data-widget_type=\"sidebar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"ocean_social_share-2\" class=\"sidebar-box widget-oceanwp-social-share social-share clr\">\t\t\t\t<ul class=\"owp-social-share style-colored name-hidden\">\r\n\t\t\t\t\t<li class=\"twitter\"><a href=\"https:\/\/twitter.com\/share?text=Use%20LEN%20function%20to%20provide%20data%20for%20RIGHT%20function&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformulas%2Fuse-len-function-to-provide-data-for-right-function%2F\" title=\"Share on X\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-twitter-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"facebook\"><a href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformulas%2Fuse-len-function-to-provide-data-for-right-function%2F\" title=\"Share on Facebook\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-facebook-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15\t\t\t\t\t\t\t\t37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11\t\t\t\t\t\t\t\t71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"linkedin\"><a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformulas%2Fuse-len-function-to-provide-data-for-right-function%2F&#038;title=Use%20LEN%20function%20to%20provide%20data%20for%20RIGHT%20function&#038;summary=FORMULAS+Use+LEN+function+to+provide+data+for+RIGHT+function+If+text+strings+you+have+in+your+range+of+data+are+not+quite+standardized+and+you+need+to+modify+them+with+one+same+formula%2C+now+you+will+learn+how+to%26hellip%3B&#038;source=https:\/\/www.excelandmacros.com\/sr\/\" title=\"Share on LinkedIn\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-linkedin-icon\" role=\"img\" viewbox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4\t\t\t\t\t\t\t\t416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1\t\t\t\t\t\t\t\t243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"viber\"><a href=\"\" title=\"Share on Viber\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-viber-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M444 49.9C431.3 38.2 379.9.9 265.3.4c0 0-135.1-8.1-200.9 52.3C27.8 89.3 14.9 143 13.5 209.5c-1.4 66.5-3.1 191.1 117\t\t\t\t\t\t\t\t224.9h.1l-.1 51.6s-.8 20.9 13 25.1c16.6 5.2 26.4-10.7 42.3-27.8 8.7-9.4 20.7-23.2 29.8-33.7 82.2 6.9 145.3-8.9 152.5-11.2 16.6-5.4 110.5-17.4\t\t\t\t\t\t\t\t125.7-142 15.8-128.6-7.6-209.8-49.8-246.5zM457.9 287c-12.9 104-89 110.6-103 115.1-6 1.9-61.5 15.7-131.2 11.2 0 0-52 62.7-68.2 79-5.3 5.3-11.1\t\t\t\t\t\t\t\t4.8-11-5.7 0-6.9.4-85.7.4-85.7-.1 0-.1 0 0 0-101.8-28.2-95.8-134.3-94.7-189.8 1.1-55.5 11.6-101 42.6-131.6 55.7-50.5 170.4-43 170.4-43 96.9.4\t\t\t\t\t\t\t\t143.3 29.6 154.1 39.4 35.7 30.6 53.9 103.8 40.6 211.1zm-139-80.8c.4 8.6-12.5 9.2-12.9.6-1.1-22-11.4-32.7-32.6-33.9-8.6-.5-7.8-13.4.7-12.9 27.9\t\t\t\t\t\t\t\t1.5 43.4 17.5 44.8 46.2zm20.3 11.3c1-42.4-25.5-75.6-75.8-79.3-8.5-.6-7.6-13.5.9-12.9 58 4.2 88.9 44.1 87.8 92.5-.1 8.6-13.1 8.2-12.9-.3zm47 13.4c.1\t\t\t\t\t\t\t\t8.6-12.9 8.7-12.9.1-.6-81.5-54.9-125.9-120.8-126.4-8.5-.1-8.5-12.9 0-12.9 73.7.5 133 51.4 133.7 139.2zM374.9 329v.2c-10.8 19-31 40-51.8\t\t\t\t\t\t\t\t33.3l-.2-.3c-21.1-5.9-70.8-31.5-102.2-56.5-16.2-12.8-31-27.9-42.4-42.4-10.3-12.9-20.7-28.2-30.8-46.6-21.3-38.5-26-55.7-26-55.7-6.7-20.8 14.2-41\t\t\t\t\t\t\t\t33.3-51.8h.2c9.2-4.8 18-3.2 23.9 3.9 0 0 12.4 14.8 17.7 22.1 5 6.8 11.7 17.7 15.2 23.8 6.1 10.9 2.3 22-3.7 26.6l-12 9.6c-6.1 4.9-5.3 14-5.3 14s17.8\t\t\t\t\t\t\t\t67.3 84.3 84.3c0 0 9.1.8 14-5.3l9.6-12c4.6-6 15.7-9.8 26.6-3.7 14.7 8.3 33.4 21.2 45.8 32.9 7 5.7 8.6 14.4 3.8 23.6z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li>\t\t\t\t<\/ul>\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-217c5cb\" data-id=\"217c5cb\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4bbc22ef elementor-widget elementor-widget-text-editor\" data-id=\"4bbc22ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If text strings you have in your range of data are not quite standardized and you need to modify them with one same formula, now you will learn how to use LEN function to provide data for RIGHT function. LEN function could be also used with other functions, such as LEFT and MID function for example, depending on your needs in particular moment.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55c9c6b elementor-widget elementor-widget-text-editor\" data-id=\"55c9c6b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Our today\u2019s topic is very connected with our previous post <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/combine-functions-to-insert-a-character-inside-a-text-string\/\">Combine functions to insert a character inside a text string<\/a>, and we hope you had the chance to read it. This post would be something like part two where we will use LEN function to handle variations in the number of characters of the string.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7cbea2b5 elementor-widget elementor-widget-heading\" data-id=\"7cbea2b5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">LEN function counts the number of characters of a text string, or to say differently, measures the length of a text string. <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07e01a3 elementor-widget elementor-widget-text-editor\" data-id=\"07e01a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This property will be very useful for us when we have different number of characters in the string we want to edit. In the example from <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/combine-functions-to-insert-a-character-inside-a-text-string\/\">part one<\/a> of this post series, we used RIGHT function to cut last four characters of the string \u201cAB0001\u201d and then we added it in our CONCATENATE function. Our final goal was to insert blank character after second character in the string and to create AB 0001 from AB0001. So, as the final result we created further formula:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa1c584 elementor-widget elementor-widget-text-editor\" data-id=\"fa1c584\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>=CONCATENATE(LEFT(A2;2);&#8221; &#8220;;RIGHT(A2;4))<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b76ca69 elementor-widget elementor-widget-text-editor\" data-id=\"b76ca69\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If these four characters are not always present, because sometimes we have three characters, sometimes two etc. we can not just give a number 4 to RIGHT function, as we did previously, but we should forward to it the remaining number of characters after first two letter characters. If we have, for example, string like \u201cAB12\u201d, then we should just forward two characters to our RIGHT function, also if the string is \u201cAB123\u201d then we should forward three remaining characters.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6632f5 elementor-widget elementor-widget-text-editor\" data-id=\"e6632f5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In order to do it we will insert LEN function inside of our RIGHT function and decrease its result for 2 which will provide it needed number of characters after measuring the length of the string. New formula will look like this:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a30b6f elementor-widget elementor-widget-text-editor\" data-id=\"2a30b6f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>=CONCATENATE(LEFT(A2;2);&#8221; &#8220;;RIGHT(A2;LEN(A2)-2))<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b1ce90 elementor-widget elementor-widget-text-editor\" data-id=\"4b1ce90\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Meaning, if we have a string \u201cAB123\u201d there are 5 characters in total. We already used first two as letter characters, so we should provide number 3 to our RIGHT function and this we will get by using LEN decreased for 2 characters.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e9f6c5 elementor-widget elementor-widget-text-editor\" data-id=\"4e9f6c5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>According to our new formula we can get results like on the picture below.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4718c4a3 elementor-widget elementor-widget-image\" data-id=\"4718c4a3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"322\" height=\"99\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/text-string-len.jpg\" class=\"attachment-large size-large wp-image-852\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6554c8f6 elementor-widget elementor-widget-text-editor\" data-id=\"6554c8f6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If you just missed details related to first part of formula, here you can read our part one post on the topic <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/combine-functions-to-insert-a-character-inside-a-text-string\/\">how to to insert a character inside a text string<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-73a17ba6\" data-id=\"73a17ba6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>FORMULAS Use LEN function to provide data for RIGHT function If text strings you have in your range of data are not quite standardized and you need to modify them with one same formula, now you will learn how to use LEN function to provide data for RIGHT function. LEN function could be also used [&hellip;]<\/p>","protected":false},"author":1,"featured_media":850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"on","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[9],"tags":[],"class_list":["post-863","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","entry","has-media"],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",1920,1080,false],"landscape":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",1920,1080,false],"portraits":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",1920,1080,false],"thumbnail":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812-150x150.jpg",150,150,true],"medium":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812-300x169.jpg",300,169,true],"large":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812-1024x576.jpg",1024,576,true],"1536x1536":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",1536,864,false],"2048x2048":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",1920,1080,false],"trp-custom-language-flag":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/concatenate-left-right-formula-e1564315991812.jpg",18,10,false]},"rttpg_author":{"display_name":"adminMilos","author_link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/author\/adminmilos\/"},"rttpg_comment":2,"rttpg_category":"<a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/category\/formulas\/\" rel=\"category tag\">Formulas<\/a>","rttpg_excerpt":"FORMULAS Use LEN function to provide data for RIGHT function If text strings you have in your range of data are not quite standardized and you need to modify them with one same formula, now you will learn how to use LEN function to provide data for RIGHT function. LEN function could be also used&hellip;","_links":{"self":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/comments?post=863"}],"version-history":[{"count":9,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/863\/revisions"}],"predecessor-version":[{"id":1311,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/863\/revisions\/1311"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media\/850"}],"wp:attachment":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media?parent=863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/categories?post=863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/tags?post=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}