Flash Fill is intuitive and won't have to have formulas or splitting wizards. Even so, it works finest when the information has steady styles and will not manage complex versions as proficiently.Copy column B and paste it into column C exactly where you should extract the first title with the total name.Then press the return vital and copy the comp