{"id":7440,"date":"2023-01-12T06:07:00","date_gmt":"2023-01-12T00:37:00","guid":{"rendered":"https:\/\/aiyoit.com\/tutorial\/?p=7440"},"modified":"2023-08-30T12:42:29","modified_gmt":"2023-08-30T07:12:29","slug":"the-text-formula-in-ms-excel","status":"publish","type":"post","link":"https:\/\/aiyoit.com\/tutorial\/the-text-formula-in-ms-excel\/","title":{"rendered":"The Text Formula in MS Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7440\" class=\"elementor elementor-7440\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-3227149f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3227149f\" 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-100 elementor-top-column elementor-element elementor-element-68574c45\" data-id=\"68574c45\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3686b6a3 elementor-shape-circle elementor-grid-0 e-grid-align-center elementor-widget elementor-widget-social-icons\" data-id=\"3686b6a3\" data-element_type=\"widget\" data-widget_type=\"social-icons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-social-icons.elementor-grid-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-mobile-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-tablet-0 .elementor-widget-container{line-height:1;font-size:0}.elementor-widget-social-icons:not(.elementor-grid-0):not(.elementor-grid-tablet-0):not(.elementor-grid-mobile-0) .elementor-grid{display:inline-grid}.elementor-widget-social-icons .elementor-grid{grid-column-gap:var(--grid-column-gap,5px);grid-row-gap:var(--grid-row-gap,5px);grid-template-columns:var(--grid-template-columns);justify-content:var(--justify-content,center);justify-items:var(--justify-content,center)}.elementor-icon.elementor-social-icon{font-size:var(--icon-size,25px);line-height:var(--icon-size,25px);width:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)));height:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)))}.elementor-social-icon{--e-social-icon-icon-color:#fff;display:inline-flex;background-color:#69727d;align-items:center;justify-content:center;text-align:center;cursor:pointer}.elementor-social-icon i{color:var(--e-social-icon-icon-color)}.elementor-social-icon svg{fill:var(--e-social-icon-icon-color)}.elementor-social-icon:last-child{margin:0}.elementor-social-icon:hover{opacity:.9;color:#fff}.elementor-social-icon-android{background-color:#a4c639}.elementor-social-icon-apple{background-color:#999}.elementor-social-icon-behance{background-color:#1769ff}.elementor-social-icon-bitbucket{background-color:#205081}.elementor-social-icon-codepen{background-color:#000}.elementor-social-icon-delicious{background-color:#39f}.elementor-social-icon-deviantart{background-color:#05cc47}.elementor-social-icon-digg{background-color:#005be2}.elementor-social-icon-dribbble{background-color:#ea4c89}.elementor-social-icon-elementor{background-color:#d30c5c}.elementor-social-icon-envelope{background-color:#ea4335}.elementor-social-icon-facebook,.elementor-social-icon-facebook-f{background-color:#3b5998}.elementor-social-icon-flickr{background-color:#0063dc}.elementor-social-icon-foursquare{background-color:#2d5be3}.elementor-social-icon-free-code-camp,.elementor-social-icon-freecodecamp{background-color:#006400}.elementor-social-icon-github{background-color:#333}.elementor-social-icon-gitlab{background-color:#e24329}.elementor-social-icon-globe{background-color:#69727d}.elementor-social-icon-google-plus,.elementor-social-icon-google-plus-g{background-color:#dd4b39}.elementor-social-icon-houzz{background-color:#7ac142}.elementor-social-icon-instagram{background-color:#262626}.elementor-social-icon-jsfiddle{background-color:#487aa2}.elementor-social-icon-link{background-color:#818a91}.elementor-social-icon-linkedin,.elementor-social-icon-linkedin-in{background-color:#0077b5}.elementor-social-icon-medium{background-color:#00ab6b}.elementor-social-icon-meetup{background-color:#ec1c40}.elementor-social-icon-mixcloud{background-color:#273a4b}.elementor-social-icon-odnoklassniki{background-color:#f4731c}.elementor-social-icon-pinterest{background-color:#bd081c}.elementor-social-icon-product-hunt{background-color:#da552f}.elementor-social-icon-reddit{background-color:#ff4500}.elementor-social-icon-rss{background-color:#f26522}.elementor-social-icon-shopping-cart{background-color:#4caf50}.elementor-social-icon-skype{background-color:#00aff0}.elementor-social-icon-slideshare{background-color:#0077b5}.elementor-social-icon-snapchat{background-color:#fffc00}.elementor-social-icon-soundcloud{background-color:#f80}.elementor-social-icon-spotify{background-color:#2ebd59}.elementor-social-icon-stack-overflow{background-color:#fe7a15}.elementor-social-icon-steam{background-color:#00adee}.elementor-social-icon-stumbleupon{background-color:#eb4924}.elementor-social-icon-telegram{background-color:#2ca5e0}.elementor-social-icon-thumb-tack{background-color:#1aa1d8}.elementor-social-icon-tripadvisor{background-color:#589442}.elementor-social-icon-tumblr{background-color:#35465c}.elementor-social-icon-twitch{background-color:#6441a5}.elementor-social-icon-twitter{background-color:#1da1f2}.elementor-social-icon-viber{background-color:#665cac}.elementor-social-icon-vimeo{background-color:#1ab7ea}.elementor-social-icon-vk{background-color:#45668e}.elementor-social-icon-weibo{background-color:#dd2430}.elementor-social-icon-weixin{background-color:#31a918}.elementor-social-icon-whatsapp{background-color:#25d366}.elementor-social-icon-wordpress{background-color:#21759b}.elementor-social-icon-xing{background-color:#026466}.elementor-social-icon-yelp{background-color:#af0606}.elementor-social-icon-youtube{background-color:#cd201f}.elementor-social-icon-500px{background-color:#0099e5}.elementor-shape-rounded .elementor-icon.elementor-social-icon{border-radius:10%}.elementor-shape-circle .elementor-icon.elementor-social-icon{border-radius:50%}<\/style>\t\t<div class=\"elementor-social-icons-wrapper elementor-grid\">\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-facebook elementor-animation-buzz elementor-repeater-item-01b5564\" href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Facebook<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-facebook\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-instagram elementor-animation-buzz elementor-repeater-item-8a90b95\" href=\"https:\/\/www.instagram.com\/aiyoitns\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Instagram<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-instagram\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-youtube elementor-animation-buzz elementor-repeater-item-567c5bb\" href=\"https:\/\/www.youtube.com\/channel\/UCiagcH73PZUdTzRySS8Axig\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Youtube<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-youtube\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-7dc99ee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dc99ee\" 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-100 elementor-top-column elementor-element elementor-element-b806b64\" data-id=\"b806b64\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8018d7e elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"8018d7e\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:&quot;.comment-container , .smart-post&quot;,&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.10.1 - 09-01-2023 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#a4afb7);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:flex;align-items:center;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#a4afb7)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color)}.elementor-toc__toggle-button{cursor:pointer;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#c2cbd2;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:flex;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2379719 elementor-widget elementor-widget-heading\" data-id=\"2379719\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Text Formula<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ff86d3 elementor-widget elementor-widget-text-editor\" data-id=\"9ff86d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>\u0907\u0938 Option \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u093e\u0930\u0947 Formulas \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932 \u091c\u093e\u0924\u0947 \u0939\u0948, \u091c\u093f\u0928\u0915\u093e Use Numbers \u0915\u094b Text Form \u092e\u0947\u0902 \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0907\u0928 Formulas \u0915\u093e Syntax \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0940\u0915\u0947 \u0915\u093e \u0939\u094b\u0924\u093e \u0939\u0948 \u2013\u00a0\u00a0\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3343660 elementor-widget elementor-widget-text-editor\" data-id=\"3343660\" 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<p>\u00a0=TEXT (Value, Format_text)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a92e43 elementor-widget elementor-widget-heading\" data-id=\"2a92e43\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">UPPER<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e9e503 elementor-widget elementor-widget-text-editor\" data-id=\"0e9e503\" 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<p>\u0915\u093f\u0938\u0940 Cell \u0915\u0947 Text \u0915\u094b UPPER Formula \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 UPPER CASE \u092e\u0947 \u092c\u0926\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1711401 elementor-widget elementor-widget-text-editor\" data-id=\"1711401\" 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<p><strong>Syntax : =Upper(text)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cfebb2a elementor-widget elementor-widget-heading\" data-id=\"cfebb2a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">LOWER<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80164d6 elementor-widget elementor-widget-text-editor\" data-id=\"80164d6\" 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<p>\u0915\u093f\u0938\u0940 Cell \u0915\u0947 Text \u0915\u094b lower Formula \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 lower case \u092e\u0947 \u092c\u0926\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93912eb elementor-widget elementor-widget-text-editor\" data-id=\"93912eb\" 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<p><strong>Syntax : =Lower(text)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-601e609 elementor-widget elementor-widget-heading\" data-id=\"601e609\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">PROPER<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee3568e elementor-widget elementor-widget-text-editor\" data-id=\"ee3568e\" 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<p>\u0915\u093f\u0938\u0940 Cell \u0915\u0947 Text \u0915\u094b Proper Formula \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 Proper Case \u092e\u0947 \u092c\u0926\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3cc835b elementor-widget elementor-widget-text-editor\" data-id=\"3cc835b\" 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<p><strong>Syntax : =Proper(text)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba49693 elementor-widget elementor-widget-image\" data-id=\"ba49693\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"578\" height=\"211\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Upper-lower-proper-Formula.png\" class=\"attachment-large size-large wp-image-7520\" alt=\"Upper lower proper Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Upper-lower-proper-Formula.png 578w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Upper-lower-proper-Formula-300x110.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Upper-lower-proper-Formula-150x55.png 150w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/>\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-858d513 elementor-widget elementor-widget-heading\" data-id=\"858d513\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">LEFT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a3ac5c elementor-widget elementor-widget-text-editor\" data-id=\"2a3ac5c\" 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<p>\u0915\u093f\u0938\u0940 Cell \u092e\u0947 Left \u0938\u0947 \u0926\u093f\u090f \u0917\u090f num_chars \u0915\u0947 According \u0909\u0924\u0928\u0947 Character Pick \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f LEFT Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-373a8ff elementor-widget elementor-widget-text-editor\" data-id=\"373a8ff\" 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<p><strong>Syntax : =Left(text, num_chars)\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ( num_chers = Number of Characters) <\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-342eb8c elementor-widget elementor-widget-heading\" data-id=\"342eb8c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">MID<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-51613bb elementor-widget elementor-widget-text-editor\" data-id=\"51613bb\" 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<p>\u0915\u093f\u0938\u0940 Cell \u092e\u0947 start_num \u0914\u0930 num_chars \u0915\u0947 According \u0909\u0924\u0928\u0947 Character Pick \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MIDDLE Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21786fe elementor-widget elementor-widget-text-editor\" data-id=\"21786fe\" 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<p><strong>Syntax : =Mid(text, start_num, num_chars)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a7ab4f elementor-widget elementor-widget-text-editor\" data-id=\"6a7ab4f\" 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<ul><li>start_num \u0915\u093e \u092e\u0924\u0932\u092c \u091c\u093f\u0938 Position \u0938\u0947 Character Pick \u0915\u0930\u0928\u0947 \u0939\u0948\u0902, \u0914\u0930 num_chars \u0915\u093e \u092e\u0924\u0932\u092c \u0915\u093f\u0924\u0928\u0947 Characters Pick \u0915\u0930\u0928\u0947 \u0939\u0948\u0902\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-683b576 elementor-widget elementor-widget-heading\" data-id=\"683b576\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">RIGHT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-400d693 elementor-widget elementor-widget-text-editor\" data-id=\"400d693\" 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<p>\u0915\u093f\u0938\u0940 Cell \u092e\u0947 Right \u0938\u0947 \u0926\u093f\u090f \u0917\u090f num_chars \u0915\u0947 According \u0909\u0924\u0928\u0947 Character Pick \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f RIGHT Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-275a632 elementor-widget elementor-widget-text-editor\" data-id=\"275a632\" 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<p><strong>Syntax : =Right(text, num_chars)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86b6e2d elementor-widget elementor-widget-image\" data-id=\"86b6e2d\" 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=\"701\" height=\"188\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Right-Formula.png\" class=\"attachment-large size-large wp-image-7518\" alt=\"Right Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Right-Formula.png 701w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Right-Formula-300x80.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Right-Formula-150x40.png 150w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/>\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-424b38d elementor-widget elementor-widget-heading\" data-id=\"424b38d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">LEN<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1341bf6 elementor-widget elementor-widget-text-editor\" data-id=\"1341bf6\" 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<p>\u0915\u093f\u0938\u0940 Cell \u092e\u0947 \u0932\u093f\u0916\u0947 Text \u092f\u093e Value \u0915\u0940 Length \u0915\u094b \u091c\u094d\u091e\u093e\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f LEN Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d97e362 elementor-widget elementor-widget-text-editor\" data-id=\"d97e362\" 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<p><strong>Syntax : =Len(text)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7373a3 elementor-widget elementor-widget-image\" data-id=\"c7373a3\" 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=\"1024\" height=\"372\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-1024x372.png\" class=\"attachment-large size-large wp-image-7517\" alt=\"LEN Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-1024x372.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-300x109.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-150x54.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-768x279.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-1536x558.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/LEN-Formula-2048x744.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\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-a2d64e0 elementor-widget elementor-widget-heading\" data-id=\"a2d64e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">CONCATENATE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fef2a11 elementor-widget elementor-widget-text-editor\" data-id=\"fef2a11\" 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<p>Concatenate Formula \u0915\u0940 Help \u0938\u0947 \u090f\u0915 \u092f\u093e \u0905\u0927\u093f\u0915 Cell \u0915\u0947 Mater \u0915\u094b \u092f\u093e Text \u0915\u094b \u0906\u092a\u0938 \u092e\u0947 Join \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c00c47d elementor-widget elementor-widget-text-editor\" data-id=\"c00c47d\" 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<p><strong>Syntax : =Concatenate(text1, text2, text3, \u2026.)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b718d50 elementor-widget elementor-widget-image\" data-id=\"b718d50\" 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=\"1024\" height=\"295\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-1024x295.png\" class=\"attachment-large size-large wp-image-7516\" alt=\"Concatenate Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-1024x295.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-300x86.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-150x43.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-768x221.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-1536x443.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Concatenate-Formula-2048x590.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\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-0d6dbff elementor-widget elementor-widget-heading\" data-id=\"0d6dbff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">TRIM<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b811cce elementor-widget elementor-widget-text-editor\" data-id=\"b811cce\" 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<p>\u0915\u093f\u0938\u0940 Cell \u092e\u0947 \u0932\u093f\u0916\u0947 Text \u0915\u0947 Extra Space \u0915\u094b Remove \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f TRIM Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36cd438 elementor-widget elementor-widget-text-editor\" data-id=\"36cd438\" 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<p><strong>Syntax : =Trim(text)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f4e332 elementor-widget elementor-widget-image\" data-id=\"1f4e332\" 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=\"1024\" height=\"308\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-1024x308.png\" class=\"attachment-large size-large wp-image-7519\" alt=\"TRIM in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-1024x308.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-300x90.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-150x45.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-768x231.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-1536x463.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/TRIM-Formula-2048x617.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\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\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-76a1543d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"76a1543d\" 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-100 elementor-top-column elementor-element elementor-element-6c9a3bed\" data-id=\"6c9a3bed\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-215a63c4 elementor-widget elementor-widget-text-editor\" data-id=\"215a63c4\" 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<p>\u0907\u0928\u094d\u0939\u0947 \u092d\u0940 \u092a\u095d\u0947 &#8212;-<br \/><a href=\"https:\/\/aiyoit.com\/tutorial\/date-and-time-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Date and Time Formulas in Excel\u00a0<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/logical-function-and-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/the-text-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Text Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/lookup-formula-reference-in-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Lookup and Reference Formula in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/financial-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Formula in Excel<\/a><\/p>\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\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-287dfa79 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"287dfa79\" 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-100 elementor-top-column elementor-element elementor-element-6d3962a1\" data-id=\"6d3962a1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-654ee055 elementor-widget elementor-widget-text-editor\" data-id=\"654ee055\" 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<p class=\"has-background\"><em>\u0906\u0936\u093e \u0915\u0930\u0924\u093e \u0939\u0942\u0901 \u0915\u0940 \u0907\u0938 Article \u0938\u0947 \u0906\u092a\u0915\u094b Text Formula \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u093f\u0932\u0940 \u0939\u094b\u0917\u0940, \u0905\u0917\u0930 \u0906\u092a \u0915\u094b Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0915\u0941\u091b \u0938\u092e\u091d \u092e\u0947\u0902 \u0906\u092f\u093e \u0939\u094b \u0924\u094b \u0905\u092a\u0928\u0947 \u0926\u094b\u0938\u094d\u0924\u094b\u0902 \u0915\u0947 \u092a\u093e\u0938 \u091c\u0930\u0942\u0930 Share \u0915\u0930\u0947 \u0924\u093e\u0915\u093f \u0909\u0928\u0915\u094b \u092d\u0940\u00a0 Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 knowledge \u092e\u093f\u0932 \u0938\u0915\u0947\u0964 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947 <strong><a href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\" rel=\"noreferrer noopener\">Facebook Page<\/a>\u00a0<\/strong>\u0915\u094b Follow \u0914\u0930\u00a0<strong><a href=\"https:\/\/www.youtube.com\/@aiyoit5339\/featured\" target=\"_blank\" rel=\"noreferrer noopener\">Youtube channel<\/a>\u00a0<\/strong>\u0915\u094b subscribe \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0905\u0917\u0930 \u0906\u092a \u0915\u093e \u0915\u094b\u0908 \u0938\u0935\u093e\u0932 \u0939\u094b \u0924\u094b comment box \u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947\u0964<\/em><\/p><p><strong>Thank You !<\/strong><\/p>\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\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-7799cefe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7799cefe\" 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-100 elementor-top-column elementor-element elementor-element-13f674a6\" data-id=\"13f674a6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d9dac0b elementor-widget elementor-widget-eael-content-ticker\" data-id=\"d9dac0b\" data-element_type=\"widget\" data-widget_type=\"eael-content-ticker.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"eael-ticker-wrap\" id=\"eael-ticker-wrap-d9dac0b\"><div class=\"ticker-badge\">\n                    <span>Trending Today<\/span>\n                <\/div><div class=\"swiper-container-wrap eael-ticker\">\n                <div class=\"swiper-container eael-content-ticker swiper-container-d9dac0b\" data-pagination=\".swiper-pagination-d9dac0b\" data-arrow-next=\".swiper-button-next-d9dac0b\" data-arrow-prev=\".swiper-button-prev-d9dac0b\" data-effect=\"slide\" data-speed=\"400\" data-autoplay=\"2000\" data-loop=\"1\" data-arrows=\"1\">\n                    <div class=\"swiper-wrapper\"><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upsi-gs-hindi-100-questions-quiz\/\" class=\"ticker-content-link\">UPSI GS &#038; Hindi &#8211; 100 Questions Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upp-quiz-questions-100\/\" class=\"ticker-content-link\">UPP Quiz Questions 100<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-photoshop-internet-test-quiz\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally, Photoshop, Internet -Test Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-test-quiz-2\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally &#8211; Test Quiz<\/a>\n        <\/div>\n    <\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"content-ticker-pagination\"><div class=\"swiper-button-next swiper-button-next-d9dac0b\"><i class=\"fas fa-angle-right\"><\/i><\/div><div class=\"swiper-button-prev swiper-button-prev-d9dac0b\"><i class=\"fas fa-angle-left\"><\/i><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-52e6b805 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"52e6b805\" 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-100 elementor-top-column elementor-element elementor-element-559eca7f\" data-id=\"559eca7f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d870539 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"1d870539\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-share-buttons.min.css\">\t\t<div class=\"elementor-grid\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_facebook\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on facebook\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_pinterest\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on pinterest\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-pinterest\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tPinterest\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_linkedin\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on linkedin\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-linkedin\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_whatsapp\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on whatsapp\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-whatsapp\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\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\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0907\u0938 Option \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u093e\u0930\u0947 Formulas \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932 \u091c\u093e\u0924\u0947 \u0939\u0948, \u091c\u093f\u0928\u0915\u093e Use Numbers \u0915\u094b Text Form \u092e\u0947\u0902 \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0907\u0928 Formulas \u0915\u093e Syntax \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0940\u0915\u0947&#8230;. <\/p>\n","protected":false},"author":6,"featured_media":7458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","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":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[44],"tags":[9,497,1740,1742,1537,1514,1545,1534,517,1736,1734,1738,1741,1739,1735,1732,1743,1733,1737],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7440"}],"collection":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7440"}],"version-history":[{"count":26,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7440\/revisions"}],"predecessor-version":[{"id":7619,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7440\/revisions\/7619"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media\/7458"}],"wp:attachment":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/categories?post=7440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}