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?

ASAP Utilities, a free Excel Add-in, has this as one of it's
features....."Delete all numbers in selection"..........it works good

http://www.asap-utilities.com/index.php?page=p_ho.php

Vaya con Dios,
Chuck, CABGx3



"Keith" wrote in message
...
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?

Try the following...

=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123 456789"))-1)

Hope this helps!

In article , Keith
wrote:

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?