Hi
Insert an empty column to right of codes (when there isn't one ready).
Select all codes, and then from Data menu TextToColumns. Set delimiter to
"-" and finish. As result you get 2 columns
123 1
123 1
1406 3
1508 6
154 8
117 5
8957 5
8957 6
When you want to preserve the old column too, then make a copy it before.
Arvi Laanemets
"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
|