Flash Fill is intuitive and does not need formulas or splitting wizards. Nevertheless, it really works best when the info has constant styles and will not tackle sophisticated variations as properly.Duplicate column B and paste it into column C where by you ought to extract the first title from your comprehensive name.An example of a analysis issue