How to bring in string from left of numbers in Excel <p>I'm trying to format a column based off of another (let's say column B2). The column contains a value like "ABC011" and I need to bring in just the letters "ABC".</p> <p>For another column I also need to bring in just the numbers "011" but without the trailing zeroes (although I imagine that if I can get the solution for the first question I'll be able to figure out the second).</p> <p>Thanks in advance.</p> <p>EDIT: The length of the characters can change but the numbers are USUALLY 2 or more digits as well as the letters.</p>