<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-7656514200244220056</id><updated>2024-08-29T17:45:48.030+05:30</updated><title type='text'>Turorial</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://dharacademyblog.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='https://dharacademyblog.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Mithun Dhar</name><uri>http://www.blogger.com/profile/02983794390554514675</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>3</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7656514200244220056.post-583660385938555807</id><published>2020-10-11T16:51:00.004+05:30</published><updated>2020-10-11T16:51:59.524+05:30</updated><title type='text'>Game Privacy Policy</title><content type='html'>&lt;h1 style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;span style=&quot;background-color: white; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2b00fe; font-size: x-large;&quot;&gt;Privacy Policy&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/h1&gt;&lt;span style=&quot;background-color: white; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px;&quot;&gt;&lt;/span&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;Mithun Dhar built the Number Puzzle app as a Free app. This SERVICE is provided by Mithun Dhar at no cost and is intended for use as is.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Number Puzzle unless otherwise defined in this Privacy Policy.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Information Collection and Use&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information, including but not limited to We are not collecting any personal information. The information that I request will be retained on your device and is not collected by me in any way.&lt;/p&gt;&lt;div style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px;&quot;&gt;&lt;p style=&quot;box-sizing: inherit; margin: 0px; padding: 0px;&quot;&gt;The app does use third party services that may collect information used to identify you.&lt;/p&gt;&lt;p style=&quot;box-sizing: inherit; margin: 0px; padding: 0px;&quot;&gt;Link to privacy policy of third party service providers used by the app&lt;/p&gt;&lt;ul style=&quot;box-sizing: inherit; list-style-image: initial; list-style-position: initial; margin: 0px; padding: 0px;&quot;&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;&lt;a href=&quot;https://www.google.com/policies/privacy/&quot; rel=&quot;noopener noreferrer&quot; style=&quot;background-color: transparent; box-sizing: inherit; color: #3273dc; cursor: pointer; text-decoration-line: none;&quot; target=&quot;_blank&quot;&gt;Google Play Services&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;&lt;a href=&quot;https://unity3d.com/legal/privacy-policy&quot; rel=&quot;noopener noreferrer&quot; style=&quot;background-color: transparent; box-sizing: inherit; color: #3273dc; cursor: pointer; text-decoration-line: none;&quot; target=&quot;_blank&quot;&gt;Unity&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Log Data&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;I want to inform you that whenever you use my Service, in a case of an error in the app I collect data and information (through third party products) on your phone called Log Data. This Log Data may include information such as your device Internet Protocol (“IP”) address, device name, operating system version, the configuration of the app when utilizing my Service, the time and date of your use of the Service, and other statistics.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Cookies&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;Cookies are files with a small amount of data that are commonly used as anonymous unique identifiers. These are sent to your browser from the websites that you visit and are stored on your device&#39;s internal memory.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;This Service does not use these “cookies” explicitly. However, the app may use third party code and libraries that use “cookies” to collect information and improve their services. You have the option to either accept or refuse these cookies and know when a cookie is being sent to your device. If you choose to refuse our cookies, you may not be able to use some portions of this Service.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Service Providers&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;I may employ third-party companies and individuals due to the following reasons:&lt;/p&gt;&lt;ul style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; list-style-image: initial; list-style-position: initial; margin: 0px; padding: 0px;&quot;&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;To facilitate our Service;&lt;/li&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;To provide the Service on our behalf;&lt;/li&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;To perform Service-related services; or&lt;/li&gt;&lt;li style=&quot;box-sizing: inherit; margin: 10px 10px 10px 2.5em; padding: 0px;&quot;&gt;To assist us in analyzing how our Service is used.&lt;/li&gt;&lt;/ul&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;I want to inform users of this Service that these third parties have access to your Personal Information. The reason is to perform the tasks assigned to them on our behalf. However, they are obligated not to disclose or use the information for any other purpose.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Security&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;I value your trust in providing us your Personal Information, thus we are striving to use commercially acceptable means of protecting it. But remember that no method of transmission over the internet, or method of electronic storage is 100% secure and reliable, and I cannot guarantee its absolute security.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Links to Other Sites&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;This Service may contain links to other sites. If you click on a third-party link, you will be directed to that site. Note that these external sites are not operated by me. Therefore, I strongly advise you to review the Privacy Policy of these websites. I have no control over and assume no responsibility for the content, privacy policies, or practices of any third-party sites or services.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Children’s Privacy&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;These Services do not address anyone under the age of 13. I do not knowingly collect personally identifiable information from children under 13. In the case I discover that a child under 13 has provided me with personal information, I immediately delete this from our servers. If you are a parent or guardian and you are aware that your child has provided us with personal information, please contact me so that I will be able to do necessary actions.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Changes to This Privacy Policy&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;I may update our Privacy Policy from time to time. Thus, you are advised to review this page periodically for any changes. I will notify you of any changes by posting the new Privacy Policy on this page.&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;This policy is effective as of 2020-10-11&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;&lt;span style=&quot;box-sizing: inherit; color: #363636; font-weight: 700;&quot;&gt;Contact Us&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;background-color: white; box-sizing: inherit; color: #4a4a4a; font-family: BlinkMacSystemFont, -apple-system, &amp;quot;Segoe UI&amp;quot;, Roboto, Oxygen, Ubuntu, Cantarell, &amp;quot;Fira Sans&amp;quot;, &amp;quot;Droid Sans&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px; padding: 0px;&quot;&gt;If you have any questions or suggestions about my Privacy Policy, do not hesitate to contact me at dhar.mithun@gmail.com.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://dharacademyblog.blogspot.com/feeds/583660385938555807/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://dharacademyblog.blogspot.com/2020/10/game-privacy-policy.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/583660385938555807'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/583660385938555807'/><link rel='alternate' type='text/html' href='https://dharacademyblog.blogspot.com/2020/10/game-privacy-policy.html' title='Game Privacy Policy'/><author><name>Mithun Dhar</name><uri>http://www.blogger.com/profile/02983794390554514675</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7656514200244220056.post-4034905798550897286</id><published>2019-01-20T13:16:00.000+05:30</published><updated>2019-01-28T13:01:35.335+05:30</updated><title type='text'>Find first name, middle name and last name in excel</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;How to
extract first name, middle name and last name from name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Example 1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto; mso-list: l4 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;1.&lt;span style=&quot;font: 7.0pt &amp;quot;Times New Roman&amp;quot;;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Suppose we have names like this below
and we want to extract first name and last name out of this list. First of all
we need to find out the pattern of this list.&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;
&lt;/span&gt;The pattern is that the first name appears after first space or period
and the 2&lt;sup&gt;nd&lt;/sup&gt; name is between 2&lt;sup&gt;nd&lt;/sup&gt; and 3&lt;sup&gt;rd&lt;/sup&gt; space
and in some cases between 3&lt;sup&gt;rd&lt;/sup&gt; and 4&lt;sup&gt;th&lt;/sup&gt; space till to the
end where the first bracket list.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;table border=&quot;1&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;MsoTableGrid&quot; style=&quot;border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;&quot;&gt;
 &lt;tbody&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;Names&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 1;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;1. Marilyn
  Monroe&amp;nbsp;(1926 –&amp;nbsp;1962) American actress, singer, model&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 2;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;2. Abraham
  Lincoln&amp;nbsp;(1809 –&amp;nbsp;1865) US President during American civil war&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 3;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;3. Mother
  Teresa&amp;nbsp;(1910 –&amp;nbsp;1997) Macedonian Catholic missionary nun&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 4;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;4. John F.
  Kennedy&amp;nbsp;(1917 –&amp;nbsp;1963) US President 1961 – 1963&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 5;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;5. Martin Luther
  King&amp;nbsp;(1929 –&amp;nbsp;1968) &amp;nbsp;American civil rights campaigner&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 6;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;6. Nelson
  Mandela&amp;nbsp;(1918 – 2013) &amp;nbsp;South African President anti-apartheid
  campaigner&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 7;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;7. Queen
  Elizabeth&amp;nbsp;II (1926 –&amp;nbsp;) British monarch since 1954&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 8;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;8. Winston
  Churchill&amp;nbsp;(1874 –&amp;nbsp;1965) British Prime Minister during WWII&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 9;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;9. Donald
  Trump&amp;nbsp;(1946 –&amp;nbsp;) Businessman, US President.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 10;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;10. Bill
  Gates&amp;nbsp;(1955 –&amp;nbsp;) American businessman, founder of Microsoft&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 11;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;11. Muhammad
  Ali&amp;nbsp;(1942 –&amp;nbsp;2016) American Boxer and civil rights campaigner&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 12;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;12. Mahatma
  Gandhi&amp;nbsp;(1869 –&amp;nbsp;1948) Leader of Indian independence movement&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 13;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;13. Margaret Thatcher&amp;nbsp;(1925
  –&amp;nbsp;2013) British Prime Minister 1979 – 1990&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 14;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;14. Christopher
  Columbus&amp;nbsp;(1451 – 1506) Italian explorer&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 15;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;15. Charles
  Darwin&amp;nbsp;(1809 –&amp;nbsp;1882) British scientist, theory of evolution&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 16;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;16. Elvis
  Presley&amp;nbsp;(1935 –&amp;nbsp;1977) American&amp;nbsp;musician&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 17;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;17. Albert Einstein&amp;nbsp;(1879
  –&amp;nbsp;1955) German scientist, theory of relativity&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;tr style=&quot;height: 15.0pt; mso-yfti-irow: 18; mso-yfti-lastrow: yes;&quot;&gt;
  &lt;td nowrap=&quot;&quot; style=&quot;border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 404.0pt;&quot; valign=&quot;top&quot; width=&quot;539&quot;&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;18. Paul
  McCartney&amp;nbsp;(1942 –&amp;nbsp;) British musician, member of Beatles&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;
 &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h1&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Extracting First Name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;To
find the first period or space, we will use MID() FUNCTION along with search()
or Find() function&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7EVLdozNPUydJ6UWxXCLZ2WA9BWXsXYHukngMxCfVPnobjwJitRNFsfoSwth6MlBGh9f_QYa07d8ONQPpbj6zjgDFt_biJ7TNYEDgmV800g9Hnt9lD7D1A2hyphenhyphenuz4G0Sv-oLM21oUng7A/s1600/ex1.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;97&quot; data-original-width=&quot;738&quot; height=&quot;84&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7EVLdozNPUydJ6UWxXCLZ2WA9BWXsXYHukngMxCfVPnobjwJitRNFsfoSwth6MlBGh9f_QYa07d8ONQPpbj6zjgDFt_biJ7TNYEDgmV800g9Hnt9lD7D1A2hyphenhyphenuz4G0Sv-oLM21oUng7A/s640/ex1.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=mid(text,start_num,num_char)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -36.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;i)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;text
= A2 (as below)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -36.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;ii)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;start_num
= char position after 1&lt;sup&gt;st&lt;/sup&gt; space&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A2,1) + 1 (result is 3 in the above case)&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -36.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;iii)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char
= length of the char to extract. In this case, it will be after start_num till
2&lt;sup&gt;nd&lt;/sup&gt; space position.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 90.0pt; mso-add-space: auto; mso-list: l2 level1 lfo2; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;a)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;First find the 2&lt;sup&gt;nd&lt;/sup&gt; space
char position&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 90.0pt; mso-add-space: auto; tab-stops: 265.55pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A2,&lt;span style=&quot;background: yellow; mso-highlight: yellow;&quot;&gt;SEARCH(&quot;
&quot;,A2,1)+1&lt;/span&gt;) (result = 11)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 90.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;In place 1 (as in ii) in
the same function, paste the same search function by adding 1. &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 90.0pt; mso-add-space: auto; mso-list: l2 level1 lfo2; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;b)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Deduct 1&lt;sup&gt;st&lt;/sup&gt; space char
position from 2&lt;sup&gt;nd&lt;/sup&gt; space char position and reduce it by 1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 90.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=&lt;a href=&quot;https://www.blogger.com/null&quot;&gt;SEARCH(&quot; &quot;,A2,SEARCH(&quot;
&quot;,A2,1)+1) &lt;/a&gt;&lt;/span&gt;&lt;span class=&quot;MsoCommentReference&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 8.0pt; line-height: 107%;&quot;&gt;&lt;!--[if !supportAnnotations]--&gt;&lt;a class=&quot;msocomanchor&quot; href=&quot;file:///E:/How%20to%20extract%20first%20name%20and%20last%20name%20from%20name.docx#_msocom_1&quot; id=&quot;_anchor_1&quot; language=&quot;JavaScript&quot; name=&quot;_msoanchor_1&quot;&gt;[A1]&lt;/a&gt;&lt;!--[endif]--&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;- SEARCH(&quot; &quot;,A2,1)-1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Now
paste the above in the mid() function&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=MID(A2,&lt;span style=&quot;background: yellow; mso-highlight: yellow;&quot;&gt;SEARCH(&quot; &quot;,A2,1)+1&lt;/span&gt;,&lt;span style=&quot;background: lime; mso-highlight: lime;&quot;&gt;SEARCH(&quot;
&quot;,A2,SEARCH(&quot; &quot;,A2,1)+1)-SEARCH(&quot; &quot;,A2,1)-1&lt;/span&gt;)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic_E-zy9wbxkT14ZXmHHu9bPC1g8zjslLYuQ-2C5UT_2TX7x14IbgiB380C5ygmZ-aE7ZNxkK0bSZpNkg4D5MVx7bS82ln9a8gyNFUbR9h0JOxYvH9eJdt40Mhrc4waHWm099lyFOdtD8/s1600/ex2.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;163&quot; data-original-width=&quot;783&quot; height=&quot;132&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic_E-zy9wbxkT14ZXmHHu9bPC1g8zjslLYuQ-2C5UT_2TX7x14IbgiB380C5ygmZ-aE7ZNxkK0bSZpNkg4D5MVx7bS82ln9a8gyNFUbR9h0JOxYvH9eJdt40Mhrc4waHWm099lyFOdtD8/s640/ex2.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-left: 7.1pt; mso-add-space: auto;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h1&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Extracting Last Name when
there is no middle name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=mid(text,start_num,num_char)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;First
find the start_num in mid() function&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;start_num would be the
position after the 2&lt;sup&gt;nd&lt;/sup&gt; space position&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot; &quot;,A2,&lt;span style=&quot;background: yellow; mso-highlight: yellow;&quot;&gt;SEARCH(&quot; &quot;,A2,1)+1&lt;/span&gt;)
+1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char
(length of char)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;a)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;First
find the 1&lt;sup&gt;st&lt;/sup&gt; bracket position [“(“]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;(&quot;,A2,1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;b)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Deduct
2 from above to get the position of last char of last name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;c)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Get
the no. of chars for &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char = (Bracket positon -2) – (2&lt;sup&gt;nd&lt;/sup&gt;
space position+1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char =
(SEARCH(&quot;(&quot;,A2,1)-2 - SEARCH(&quot; &quot;,A2,SEARCH(&quot;
&quot;,A2,1)+1))&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Now
create the final formula to the get the last name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-left: 7.1pt; mso-add-space: auto;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=MID(A2,&lt;span style=&quot;background: lime; mso-highlight: lime;&quot;&gt;SEARCH(&quot; &quot;,A2,SEARCH(&quot; &quot;,A2,1)+1)+1&lt;/span&gt;,&lt;span style=&quot;background: yellow; mso-highlight: yellow;&quot;&gt;SEARCH(&quot;(&quot;,A2,1)-2-SEARCH(&quot;
&quot;,A2,SEARCH(&quot; &quot;,A2,1)+1)&lt;/span&gt;)&lt;/span&gt;&lt;/div&gt;
&lt;h1&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Extracting Last Name when
there is middle name&lt;/span&gt;&lt;/h1&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=mid(text,start_num,num_char)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin2io8HHpp6iXJIBU7EupUJk8MUAd3Ki01OJEtDyjXFn5zj2bPCL9-i3sYw_566UZvYuEBOkHB2YpJOOvGpq2tY2VNyWQ9JuSFVInOzdo_P4a2z4vVLvnfyWYpMacULGvvXdpqvj8ff5M/s1600/ex4.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;239&quot; data-original-width=&quot;766&quot; height=&quot;198&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin2io8HHpp6iXJIBU7EupUJk8MUAd3Ki01OJEtDyjXFn5zj2bPCL9-i3sYw_566UZvYuEBOkHB2YpJOOvGpq2tY2VNyWQ9JuSFVInOzdo_P4a2z4vVLvnfyWYpMacULGvvXdpqvj8ff5M/s640/ex4.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;First
find the start_num in mid() function&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;start_num would be the
position after the 3&lt;sup&gt;rd&lt;/sup&gt; space position&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A6,SEARCH(&quot; &quot;,A6,SEARCH(&quot; &quot;,A6,1)+1)+1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;In order create this
function, use the following technique:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 50.2pt; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;symbol&amp;quot;; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;&quot;&gt;·&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A6,&lt;span style=&quot;background: aqua; mso-highlight: aqua;&quot;&gt;1&lt;/span&gt;)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 50.2pt; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;symbol&amp;quot;; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;&quot;&gt;·&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A6, &lt;span style=&quot;background: aqua; mso-highlight: aqua;&quot;&gt;SEARCH(&quot;
&quot;,A6,&lt;/span&gt;&lt;span style=&quot;background: fuchsia; mso-highlight: fuchsia;&quot;&gt;1&lt;/span&gt;&lt;span style=&quot;background: aqua; mso-highlight: aqua;&quot;&gt;)+1&lt;/span&gt;) [&lt;i&gt;put the same function in place of 1 (start_num) and add 1&lt;/i&gt;]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 50.2pt; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;symbol&amp;quot;; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;&quot;&gt;·&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;
&quot;,A6,SEARCH(&quot; &quot;,A6,&lt;span style=&quot;background: fuchsia; mso-highlight: fuchsia;&quot;&gt;SEARCH(&quot; &quot;,A6,1)+1&lt;/span&gt;)+1) [&lt;i&gt;put the same function in place of 1 (start_num) and add 1&lt;/i&gt;]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char
(length of char)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;a)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;First
find the position of 1&lt;sup&gt;st&lt;/sup&gt; bracket position [“(“]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;(&quot;,A6,1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;b)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Deduct
2 from above to get the position of last char of last name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot;(&quot;,A6,1)-2&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;c)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Find
the position of 1&lt;sup&gt;st&lt;/sup&gt; char of last name just after the 3&lt;sup&gt;rd&lt;/sup&gt;
space position&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 72.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=SEARCH(&quot; &quot;,A6,SEARCH(&quot;
&quot;,A6,SEARCH(&quot; &quot;,A6,1)+1)+1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 14.2pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: 21.8pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;&quot;&gt;d)&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Get
the no. of chars for &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char = (b - c)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent: 36.0pt;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;num_char = (SEARCH(&quot;(&quot;,A6,1)-2
- =SEARCH(&quot; &quot;,A6,SEARCH(&quot; &quot;,A6,SEARCH(&quot; &quot;,A6,1)+1)+1)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;wingdings&amp;quot;; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;&quot;&gt;v&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;
&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Now
create the final formula to the get the last name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 18.0pt; mso-add-space: auto;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=&lt;/span&gt; &lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;=MID(A6,SEARCH(&quot; &quot;,A6,SEARCH(&quot;
&quot;,A6,SEARCH(&quot;
&quot;,A6,1)+1)+1)+1,SEARCH(&quot;(&quot;,A6,1)-2-SEARCH(&quot;
&quot;,A6,SEARCH(&quot; &quot;,A6,SEARCH(&quot; &quot;,A6,1)+1)+1))&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 54.0pt; mso-add-space: auto;&quot;&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;!--[if !supportAnnotations]--&gt;

&lt;br /&gt;
&lt;hr align=&quot;left&quot; class=&quot;msocomoff&quot; size=&quot;1&quot; width=&quot;33%&quot; /&gt;
&lt;!--[endif]--&gt;

&lt;br /&gt;
&lt;div&gt;
&lt;!--[if !supportAnnotations]--&gt;

&lt;br /&gt;
&lt;div class=&quot;msocomtxt&quot; id=&quot;_com_1&quot; language=&quot;JavaScript&quot;&gt;
&lt;!--[endif]--&gt;&lt;!--[if !supportAnnotations]--&gt;&lt;a href=&quot;https://www.blogger.com/null&quot; name=&quot;_msocom_1&quot;&gt;&lt;/a&gt;&lt;!--[endif]--&gt;

&lt;br /&gt;
&lt;div class=&quot;MsoCommentText&quot;&gt;
&lt;span class=&quot;MsoCommentReference&quot;&gt;&lt;span style=&quot;font-size: 8.0pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoCommentText&quot;&gt;
&lt;span class=&quot;MsoCommentReference&quot;&gt;&lt;span style=&quot;font-size: 8.0pt;&quot;&gt;&amp;nbsp;&lt;!--[if !supportAnnotations]--&gt;&lt;a class=&quot;msocomoff&quot; href=&quot;file:///E:/How%20to%20extract%20first%20name%20and%20last%20name%20from%20name.docx#_msoanchor_1&quot;&gt;[A1]&lt;/a&gt;&lt;!--[endif]--&gt;&lt;/span&gt;&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/div&gt;
&lt;!--[if !supportAnnotations]--&gt;&lt;/div&gt;
&lt;!--[endif]--&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='https://dharacademyblog.blogspot.com/feeds/4034905798550897286/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://dharacademyblog.blogspot.com/2019/01/find-first-name-middle-last-name-excel-formula.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/4034905798550897286'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/4034905798550897286'/><link rel='alternate' type='text/html' href='https://dharacademyblog.blogspot.com/2019/01/find-first-name-middle-last-name-excel-formula.html' title='Find first name, middle name and last name in excel'/><author><name>Mithun Dhar</name><uri>http://www.blogger.com/profile/02983794390554514675</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7EVLdozNPUydJ6UWxXCLZ2WA9BWXsXYHukngMxCfVPnobjwJitRNFsfoSwth6MlBGh9f_QYa07d8ONQPpbj6zjgDFt_biJ7TNYEDgmV800g9Hnt9lD7D1A2hyphenhyphenuz4G0Sv-oLM21oUng7A/s72-c/ex1.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7656514200244220056.post-4643820715369530338</id><published>2019-01-01T10:50:00.002+05:30</published><updated>2019-01-06T16:38:21.133+05:30</updated><title type='text'>Tableau with Sql Server Example 1</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
1. Suppose there are 10 types of defects allocated to different products and the database is built like this example below. Product 12244 has defect type 5,6,8,9 and 10 etc..&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYIad6qhKuqM2wM3MYJrwE6zv5jEn2fUlToogd9IHKQwtFQgoNu6oGwXfHLAv9q7g1oC6RI67W5r7TUTzGMMzo-0s0tCNygDKGrZ0SLHVFzB610Wp3W5MgjZa4iAKy0L32L_wf683erHs/s1600/sqldata.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;780&quot; data-original-width=&quot;1040&quot; height=&quot;480&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYIad6qhKuqM2wM3MYJrwE6zv5jEn2fUlToogd9IHKQwtFQgoNu6oGwXfHLAv9q7g1oC6RI67W5r7TUTzGMMzo-0s0tCNygDKGrZ0SLHVFzB610Wp3W5MgjZa4iAKy0L32L_wf683erHs/s640/sqldata.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
2. If we plot this data directly in tableau, generating dashboards will be a bit difficult. In order to visualize the data in tableau easily, we need to arrange this data through a custom query.&lt;br /&gt;
3. Write the query in SSMS like below:&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ProductID,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Product_Name,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&#39;Defect_Type1&#39; as Type,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type1 as Defect_Desc&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;from dbo.Defects&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
4. This will pull all the records of the first defect &quot;Defect_Type1&quot;. Similarly, copy this code above and paste after this code with Union All and change the 2nd defect to &quot;Defect_Type2&quot;, see below:&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ProductID,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Product_Name,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&#39;Defect_Type1&#39; as Type,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type1 as Defect_Desc&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;from dbo.Defects&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ProductID,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Product_Name,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&#39;Defect_Type2&#39; as Type,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type2 as Defect_Desc&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;from dbo.Defects&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
5. Continue the same with other defects:&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type1&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type1 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type2 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type3 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type4 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type5 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type6 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type7 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type8 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type9 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;UNION ALL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;SELECT ProductID, Product_Name,&#39;Defect_Type2&#39; as Type,&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Defect_Type10 as Defect_Desc from dbo.Defects&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;6. This above code need to be used in Tableau&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;7. Open Tableau and connect the SQL Server database instance&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;8. Click on &quot;New Custom SQL&quot; under Data Source.&lt;/span&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0r9Nxqhr8eBH_qTcVRfdqqy9yzFZaDPNi0zJkrTtgpc0g-XufqgDLS1bHm29CZjJWolZT2oCZndjEGA5_EoEk-xx7Q9H1Zd208eBrZgemOxlSkRXtJ88QB2PDMtG9B76OV16mR6qX24g/s1600/tableau1.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1016&quot; data-original-width=&quot;956&quot; height=&quot;640&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0r9Nxqhr8eBH_qTcVRfdqqy9yzFZaDPNi0zJkrTtgpc0g-XufqgDLS1bHm29CZjJWolZT2oCZndjEGA5_EoEk-xx7Q9H1Zd208eBrZgemOxlSkRXtJ88QB2PDMtG9B76OV16mR6qX24g/s640/tableau1.png&quot; width=&quot;602&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;
9. A dialog box will appear. Paste the SQL query, as below and click Ok:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiypp5T8DzkgoGMprF_tX9GU9Bzvtai-nnLNjYwGrDUe4t9RVCvx5j_3S7SMU1ntLvRkFslYhDvKmDuxmEcEfCuSVvTSPwbCXsIxrkMq8mP1wrLZ6V0VKM6dSDwjXfRMdH-M8-RZeNl4q8/s1600/tableau2.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;645&quot; data-original-width=&quot;956&quot; height=&quot;430&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiypp5T8DzkgoGMprF_tX9GU9Bzvtai-nnLNjYwGrDUe4t9RVCvx5j_3S7SMU1ntLvRkFslYhDvKmDuxmEcEfCuSVvTSPwbCXsIxrkMq8mP1wrLZ6V0VKM6dSDwjXfRMdH-M8-RZeNl4q8/s640/tableau2.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
10. It will look like this&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxaxipk2HnXxWhZw-yjpyuAhhvpd6hVyp4MC5Umge1Fd3J0X_zynT5mne8wLIjC1RZotJEVvC8Gt_f_q52ZOaWdE2IVmbFmxmKFT-o4-GbeiljjlaX_4ZVhf_6WIYWn8mwlMJRCnfC-dw/s1600/tableau3.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;895&quot; data-original-width=&quot;956&quot; height=&quot;598&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxaxipk2HnXxWhZw-yjpyuAhhvpd6hVyp4MC5Umge1Fd3J0X_zynT5mne8wLIjC1RZotJEVvC8Gt_f_q52ZOaWdE2IVmbFmxmKFT-o4-GbeiljjlaX_4ZVhf_6WIYWn8mwlMJRCnfC-dw/s640/tableau3.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
11. Now prepare your dashboard as per your requirement.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI8beZxoXaWdWPUF84hD9urF95cPUJNYhyhoSHts4cIC2yytKmBuHJnVnwjtrB4SCyepwDYbIde1DyokJFJjDuzcAstNWT7SshSlCWPi2CThgT0RPkIKqktwnDX_Q61BrO-5sTGWBBnIw/s1600/tableau4.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;809&quot; data-original-width=&quot;1600&quot; height=&quot;322&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI8beZxoXaWdWPUF84hD9urF95cPUJNYhyhoSHts4cIC2yytKmBuHJnVnwjtrB4SCyepwDYbIde1DyokJFJjDuzcAstNWT7SshSlCWPi2CThgT0RPkIKqktwnDX_Q61BrO-5sTGWBBnIw/s640/tableau4.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='https://dharacademyblog.blogspot.com/feeds/4643820715369530338/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://dharacademyblog.blogspot.com/2019/01/tableau-sql-server-stored-procedure.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/4643820715369530338'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7656514200244220056/posts/default/4643820715369530338'/><link rel='alternate' type='text/html' href='https://dharacademyblog.blogspot.com/2019/01/tableau-sql-server-stored-procedure.html' title='Tableau with Sql Server Example 1'/><author><name>Mithun Dhar</name><uri>http://www.blogger.com/profile/02983794390554514675</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYIad6qhKuqM2wM3MYJrwE6zv5jEn2fUlToogd9IHKQwtFQgoNu6oGwXfHLAv9q7g1oC6RI67W5r7TUTzGMMzo-0s0tCNygDKGrZ0SLHVFzB610Wp3W5MgjZa4iAKy0L32L_wf683erHs/s72-c/sqldata.png" height="72" width="72"/><thr:total>0</thr:total></entry></feed>