{"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 Parse With The VBA Split Function - My Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"n859auEwYX\"><a href=\"https:\/\/vbastring.com\/blog\/2018\/11\/07\/how-to-parse-with-the-vba-split-function\/\">How To Parse With The VBA Split Function<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vbastring.com\/blog\/2018\/11\/07\/how-to-parse-with-the-vba-split-function\/embed\/#?secret=n859auEwYX\" width=\"600\" height=\"338\" title=\"&#8220;How To Parse With The VBA Split Function&#8221; &#8212; My Blog\" data-secret=\"n859auEwYX\" 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":"So you get a list of names and your boss wants you to separate the last name and the first name into different columns. Many time you want to do this so you can sort by either the first name or last name columns. You can use the vba &#8220;split&#8221; function for this purpose. Step [&hellip;]","thumbnail_url":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2018\/11\/vba_split_function_1.png"}