Don't under estimate the power of basic formatting. Techniques for pulling a part data. You have used Text To Column but have you tried Flash Fill. Changing Settings to force data to perform differently.