Parsing a customer ID

[Reaper]

I have a database with customer information that was imported from an old Excel file. There are dozens of customers that are identified by an ID that is part letters and part numbers, i.e.,


ABC-001, etc. The reason for the number portion is that some customers have multiple locations so it is used to distinguish them.

The number of letters and numbers is pretty random and could be 2 to 4 letters or numbers. Who knows why, it's old and I inherited the problem.

What I need to do is pull the letter part off the ID and use it elsewhere to identify materials received from a particular customer.

Is there a way to use VBA to pull that portion of the ID up to, but not including the dash? It obviously needs to react to the varying number of letters.

Thanks for your help.

[ketbdnetbp]

Reaper -

Assuming the letters appear first, you could try something like:

Left([ID],InStr(1,[ID],"-")-1)

All the best,

Jim