{"version":"1.0","provider_name":"My Blog","provider_url":"https:\/\/vbastring.com\/blog","author_name":"admin","author_url":"https:\/\/vbastring.com\/blog\/author\/admin\/","title":"How To Have VBA Parse A Name String - My Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"VDexyBUFdv\"><a href=\"https:\/\/vbastring.com\/blog\/2020\/05\/09\/how-to-have-vba-parse-a-name-string\/\">How To Have VBA Parse A Name String<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vbastring.com\/blog\/2020\/05\/09\/how-to-have-vba-parse-a-name-string\/embed\/#?secret=VDexyBUFdv\" width=\"600\" height=\"338\" title=\"&#8220;How To Have VBA Parse A Name String&#8221; &#8212; My Blog\" data-secret=\"VDexyBUFdv\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/vbastring.com\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"This post was actually an answer to someone&#8217;s question on one of my videos from a few years back. https:\/\/www.youtube.com\/watch?v=UspqR0g4XyU The comment was: How would you do this for the last name? Or second last name? How to find the space after the first space, and the space after the second space? And then, if [&hellip;]","thumbnail_url":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2020\/05\/How-To-Have-VBA-Parse-A-Name-String.png"}