extracting text only
I have a column in a spreadsheet that contains a code. The code starts
with 2 - 4 letters then finishes with a series of numbers.
E.G. AGB7655
How can I extract only the letters at the beginning, when I don't know
how many there are going to be?
|