Delete added comments

[Doman]

Hi!

I got this column where article numbers (text and numbers combined) are
listed. A comment is added to each article number and is written in
different languages.

How do I delete this comment so only the article numbers remain without
the comment?
Example:

COLUMN A
9857855455 - Wheel
5845-565 - Screw
268749-001 - Chip
9857855455 - Hjul
5845-565 - Skruv
9857855455 - Wheel
268749-001 - Chip

WHAT I WANT:
9857855455
5845-565
268749-001
9857855455
5845-565
9857855455
268749-001


Thanks for any help!

 

[Bondi]

Hi!

I got this column where article numbers (text and numbers combined) are
listed. A comment is added to each article number and is written in
different languages.

How do I delete this comment so only the article numbers remain without
the comment?
Example:

COLUMN A
9857855455 - Wheel
5845-565 - Screw
268749-001 - Chip
9857855455 - Hjul
5845-565 - Skruv
9857855455 - Wheel
268749-001 - Chip

WHAT I WANT:
9857855455
5845-565
268749-001
9857855455
5845-565
9857855455
268749-001


Thanks for any help!

Hi Doman,

Maybe you can use a helper column to the right of your list and the
copy down something like this:

=LEFT(A1,SEARCH(" ",A1,1))

This will look for the first Space in your cell and take the stuff to
the left of it. It seemed to work on your sample data.

Regards,
Bondi

 

[Special-K]

Assuming *all* your data has " - " in each entry try this function

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

Regards
Special-K

 

[Doman]

Thanks for the solution! Easy and handy