{"id":2585,"date":"2013-11-15T11:53:21","date_gmt":"2013-11-15T11:53:21","guid":{"rendered":"http:\/\/www.club4ca.com\/formats\/?p=2585"},"modified":"2013-11-15T11:53:21","modified_gmt":"2013-11-15T11:53:21","slug":"excel-separate-first-and-last-name-and-other-formulas","status":"publish","type":"post","link":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/","title":{"rendered":"Excel Separate First and Last Name and Other Formulas"},"content":{"rendered":"<div>\n<ol>MS Excel Formulas for<\/p>\n<li><strong>Split Forename and Surname<\/strong><\/li>\n<li>Finding the Last name when a Middle name is present<\/li>\n<li>Finding the Middle name<\/li>\n<li>When Company Pays Salary to its Clients with increased rates, So Find Increased Amount<\/li>\n<li>When Company Pays Salary to its Clients with increased rates, So Find Total Amount after Increased Amount.<\/li>\n<li>Preparing of Budget from Current Year Available Figure and Their %<\/li>\n<\/ol>\n<\/div>\n<div><\/div>\n<div><strong><a href=\"https:\/\/www.club4ca.com\/formats\/wp-content\/uploads\/2013\/11\/workbook-excel-formula.xlsx\">Click Here To Download workbook excel formula<\/a><\/strong><\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>MS Excel Formulas for Split Forename and Surname Finding the Last name when a Middle name is present Finding the Middle name When Company Pays Salary to its Clients with increased rates, So Find Increased Amount When Company Pays Salary to its Clients with increased rates, So Find Total Amount after Increased Amount. Preparing of Budget from Current Year Available Figure and Their % Click Here To Download workbook excel formula<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[747],"class_list":["post-2585","post","type-post","status-publish","format-standard","hentry","category-students","tag-formulas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Separate First and Last Name and Other Formulas<\/title>\n<meta name=\"description\" content=\"Excel Separate First and Last Name and Other Formulas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Separate First and Last Name and Other Formulas\" \/>\n<meta property=\"og:description\" content=\"Excel Separate First and Last Name and Other Formulas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"CA CLUB\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-15T11:53:21+00:00\" \/>\n<meta name=\"author\" content=\"Sara Mathur\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sara Mathur\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/\"},\"author\":{\"name\":\"Sara Mathur\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/#\\\/schema\\\/person\\\/e98b26a37c05e27e143c6a39d0fa965a\"},\"headline\":\"Excel Separate First and Last Name and Other Formulas\",\"datePublished\":\"2013-11-15T11:53:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/\"},\"wordCount\":79,\"commentCount\":0,\"keywords\":[\"Formulas\"],\"articleSection\":[\"Students\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/\",\"url\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/\",\"name\":\"Excel Separate First and Last Name and Other Formulas\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/#website\"},\"datePublished\":\"2013-11-15T11:53:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/#\\\/schema\\\/person\\\/e98b26a37c05e27e143c6a39d0fa965a\"},\"description\":\"Excel Separate First and Last Name and Other Formulas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/students\\\/excel-separate-first-and-last-name-and-other-formulas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Separate First and Last Name and Other Formulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/#website\",\"url\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/\",\"name\":\"CA CLUB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/#\\\/schema\\\/person\\\/e98b26a37c05e27e143c6a39d0fa965a\",\"name\":\"Sara Mathur\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g\",\"caption\":\"Sara Mathur\"},\"url\":\"https:\\\/\\\/www.club4ca.com\\\/formats\\\/author\\\/casara\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Separate First and Last Name and Other Formulas","description":"Excel Separate First and Last Name and Other Formulas.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/","og_locale":"en_US","og_type":"article","og_title":"Excel Separate First and Last Name and Other Formulas","og_description":"Excel Separate First and Last Name and Other Formulas.","og_url":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/","og_site_name":"CA CLUB","article_published_time":"2013-11-15T11:53:21+00:00","author":"Sara Mathur","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sara Mathur"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/#article","isPartOf":{"@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/"},"author":{"name":"Sara Mathur","@id":"https:\/\/www.club4ca.com\/formats\/#\/schema\/person\/e98b26a37c05e27e143c6a39d0fa965a"},"headline":"Excel Separate First and Last Name and Other Formulas","datePublished":"2013-11-15T11:53:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/"},"wordCount":79,"commentCount":0,"keywords":["Formulas"],"articleSection":["Students"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/","url":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/","name":"Excel Separate First and Last Name and Other Formulas","isPartOf":{"@id":"https:\/\/www.club4ca.com\/formats\/#website"},"datePublished":"2013-11-15T11:53:21+00:00","author":{"@id":"https:\/\/www.club4ca.com\/formats\/#\/schema\/person\/e98b26a37c05e27e143c6a39d0fa965a"},"description":"Excel Separate First and Last Name and Other Formulas.","breadcrumb":{"@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.club4ca.com\/formats\/students\/excel-separate-first-and-last-name-and-other-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.club4ca.com\/formats\/"},{"@type":"ListItem","position":2,"name":"Excel Separate First and Last Name and Other Formulas"}]},{"@type":"WebSite","@id":"https:\/\/www.club4ca.com\/formats\/#website","url":"https:\/\/www.club4ca.com\/formats\/","name":"CA CLUB","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.club4ca.com\/formats\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.club4ca.com\/formats\/#\/schema\/person\/e98b26a37c05e27e143c6a39d0fa965a","name":"Sara Mathur","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4dc03c276825952a7dce471f8cf845e69650803ee215e4692cd7d4383cd1a4e3?s=96&d=retro&r=g","caption":"Sara Mathur"},"url":"https:\/\/www.club4ca.com\/formats\/author\/casara\/"}]}},"_links":{"self":[{"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/posts\/2585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/comments?post=2585"}],"version-history":[{"count":0,"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/posts\/2585\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/media?parent=2585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/categories?post=2585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.club4ca.com\/formats\/wp-json\/wp\/v2\/tags?post=2585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}