Copy column B and paste it into column D wherever you wish to extract the final title in the comprehensive name.So in our case in point, If you would like the final names to appear in column D, you'll be able to only form the subsequent method in cell D2:Steve Scott I am a massive admirer of Microsoft Excel and really like sharing my information th