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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extra string before a specific character 1
Remove Identical words 0
Making a macro only work on certain files 2
pulling certain characters from a string of text 3
Left Function 1
LookUP certain words and return back corresponding values 2
Pullng data out of string of text 4
lookup text within string of text??? 0

Top