Lets say.. Data is in below format.
So, if we need only the first part with Text, we can use Some array Formula or some long formula to track 1st Numeric and 1st Text, then according return, we can use Concat both Returns..
Excel 2013, make all these concept, within a simple Flash Fill.
You just have to type the pattern to get the data.
If you need only Number or only text, you can do this by simple manual input.
take a look at the bottom screen, No Code, No Formula, only Excel 2013, Flash Fill..
Just few Manual Step..