Seperating first few variable length letters(alphas) from numerics

Originally Posted by AstToTheRegionalMGR

Can you attach sample data? It's hard to understand what you mean without examples of the data

Apologies, I had a copy & paste breakdown, first table has now been corrected.