{"id":853,"date":"2019-07-28T12:01:00","date_gmt":"2019-07-28T12:01:00","guid":{"rendered":"https:\/\/www.excelandmacros.com\/?p=853"},"modified":"2022-12-14T21:55:58","modified_gmt":"2022-12-14T21:55:58","slug":"combine-functions-to-insert-a-character-inside-a-text-string","status":"publish","type":"post","link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/combine-functions-to-insert-a-character-inside-a-text-string\/","title":{"rendered":"Combine functions to insert a character inside a text string"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"853\" class=\"elementor elementor-853\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4728d807 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"4728d807\" 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-64617790\" data-id=\"64617790\" 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-602048d4 elementor-widget elementor-widget-text-editor\" data-id=\"602048d4\" 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-30dc60a7 elementor-widget elementor-widget-heading\" data-id=\"30dc60a7\" 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\">Combine functions to insert a character inside a text string<\/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-32a3abc0 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"32a3abc0\" 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-54546ffc\" data-id=\"54546ffc\" 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-12a62582 elementor-widget elementor-widget-sidebar\" data-id=\"12a62582\" 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=Combine%20functions%20to%20insert%20a%20character%20inside%20a%20text%20string&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fformulas%2Fcombine-functions-to-insert-a-character-inside-a-text-string%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%2Fcombine-functions-to-insert-a-character-inside-a-text-string%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%2Fcombine-functions-to-insert-a-character-inside-a-text-string%2F&#038;title=Combine%20functions%20to%20insert%20a%20character%20inside%20a%20text%20string&#038;summary=FORMULAS+Combine+functions+to+insert+a+character+inside+a+text+string+Using+nested+functions+%28combine+functions%29+in+Excel+formula+is+very+powerful+technique+which+can+save+you+hours+of+your+precious+time.+Few+days+ago%2C+I+had+a+chance+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-333a1710\" data-id=\"333a1710\" 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-350b3c90 elementor-widget elementor-widget-heading\" data-id=\"350b3c90\" 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\">Using nested functions (combine functions) in Excel formula is very powerful technique which can save you hours of your precious time.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c69b877 elementor-widget elementor-widget-text-editor\" data-id=\"3c69b877\" 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>Few days ago, I had a chance to help one of my colleagues to resolve one formula issue. The invoice number needed to be created based on existing text string with adding one blank character inside the string. For example, using text string \u201cAB0001\u201d we should generate invoice number \u201cAB 0001\u201d. There was a big <strong>range of data<\/strong> waiting to be edited in this way, so that final invoice numbers could be used further in the data analysis.<\/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-4a3eb05 elementor-widget elementor-widget-text-editor\" data-id=\"4a3eb05\" 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>Definitely, this could be done manually, but when you have a great amount of data this manual work is killing your motivation and your efficiency drops dramatically. Not to mention probability of making a mistake, which will in the end take you even more time to fix.<\/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-f4f2293 elementor-widget elementor-widget-text-editor\" data-id=\"f4f2293\" 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>Great thing with using <strong>Excel functions<\/strong> is that you can combine them and use their individual results in one common formula to get final result you need. The most important thing when you <strong>combine functions<\/strong> is that you know the optimal function combination.<\/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-f7f3249 elementor-widget elementor-widget-text-editor\" data-id=\"f7f3249\" 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>The best way to find out which functions are the best for your task is that you make the analysis of the steps.<\/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-1fe80a3 elementor-widget elementor-widget-text-editor\" data-id=\"1fe80a3\" 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>Let\u2019s present this technique using our example from above. There are a few different methods and <strong>formulas<\/strong> you could use for this kind of task, depending on how much your data are standardized. In our case we had two letter characters followed by four number characters, and we should add blank character after second letter character from the left. This was the same request for each of our invoice numbers. Knowing this, we decided it is the most optimal solution for us to use further functions: CONCATENATE, LEFT and RIGHT.<\/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-636d571 elementor-widget elementor-widget-text-editor\" data-id=\"636d571\" 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>The idea was to use <strong>CONCATENATE<\/strong> as main function. Inside of it we would use <strong>LEFT function<\/strong> to select letter characters as first element of concatenation, then we would add blank character as second element and finally <strong>RIGHT function<\/strong> to select number characters as third element of concatenation. We tried it and it was like a magic. The formula we created looked just 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-d784df5 elementor-widget elementor-widget-text-editor\" data-id=\"d784df5\" 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-b7b0780 elementor-widget elementor-widget-text-editor\" data-id=\"b7b0780\" 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>Data set edited with this formula would create the result like on the further picture.<\/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-20df7d3c elementor-widget elementor-widget-image\" data-id=\"20df7d3c\" 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 fetchpriority=\"high\" decoding=\"async\" width=\"281\" height=\"386\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2019\/07\/text-string-concatenate.jpg\" class=\"attachment-large size-large wp-image-851\" 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-3a966302 elementor-widget elementor-widget-heading\" data-id=\"3a966302\" 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\">But what if you have the strings with different number of characters?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d3d8928 elementor-widget elementor-widget-text-editor\" data-id=\"6d3d8928\" 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 have the strings with different number of characters in your range of data this is little more complicated but don\u2019t be worry, just read further. We will add one more function in the formula and it will be done in the blink of an eye, too. We will enhance existing formula to adjust string length variations.<\/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-84c040a elementor-widget elementor-widget-text-editor\" data-id=\"84c040a\" 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>So, if text strings in your data set are not quite standardized here you can find out <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/use-len-function-to-provide-data-for-right-function\/\">how to use LEN function to provide data for RIGHT function<\/a> and insert a character inside a text string.<\/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-315f52a0\" data-id=\"315f52a0\" 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 Combine functions to insert a character inside a text string Using nested functions (combine functions) in Excel formula is very powerful technique which can save you hours of your precious time. Few days ago, I had a chance to help one of my colleagues to resolve one formula issue. The invoice number needed to [&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-853","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":1,"rttpg_category":"<a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/category\/formulas\/\" rel=\"category tag\">Formulas<\/a>","rttpg_excerpt":"FORMULAS Combine functions to insert a character inside a text string Using nested functions (combine functions) in Excel formula is very powerful technique which can save you hours of your precious time. Few days ago, I had a chance to help one of my colleagues to resolve one formula issue. The invoice number needed to&hellip;","_links":{"self":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/853","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=853"}],"version-history":[{"count":13,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/853\/revisions"}],"predecessor-version":[{"id":1318,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/853\/revisions\/1318"}],"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=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/categories?post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/tags?post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}