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

-- Carlos

"mike meyer" wrote in message
...
I have some product codes in a column:

123-1
123-3
1406-3
1508-6
154-8
117-5
8957-5
8957-6

I need to extract the main product code left of the dash into the next
column.
I know I have seen this done, just don't remember how it was accomplished.

Thanks in advance,
Mike