On Fri, 2 Apr 2010 18:54:14 -0700 (PDT), cstang wrote:

Hi,
Can anyone pls help me with...Thanks in advance.

ColumnC
P5704
P5822(AB)
CA072407
P6384A
SGA 525
K2201/367
K402AA

Result in ColumnB as:
P
P
CA
P
SGA
K
K
Thanks in advance.

CSTANG


=LEFT(C1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C1&"012345 6789"))-1)

--ron