Extra string before a specific character

[Sandra]

I have a column of data, like CA-, THAMES-, AWR-. etc. I want to pull all
data before the "-". It could be 2 characters to 6. Any ideas? Thanks.

 

[Pete_UK]

Try this:

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

assuming your test is in A1, then copy down as required.

Hope this helps.

Pete