Pull string before a certain character

S

Sandra

I have a column with CA-, AWR-, THAMES-, etc. I want to pull the string
before the "-". It could be 2 to 6 characters long. Any ideas will be
appreciated. Thanks.
 
K

Kevin B

The following formula will perform the extract you need:

=LEFT(A1,FIND("-",A1,1)-1)

Change cell A1 to match the cell you text value is in.
 
Top