Thanks (everyone) for the quick response, it worked perfectly.

"Teethless mama" wrote:

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

"pemmert" wrote:

Is there a function (or other Excel ability) to remove, in a single cell,
text after a certain character such as "-" e.g. to return "US" for
"US-AF-MIL" or "dot" for "dot-com"?