View Single Post
  #1   Report Post  
Keith
 
Posts: n/a
Default 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?