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!


--
Doman
------------------------------------------------------------------------
Doman's Profile: http://www.excelforum.com/member.php...o&userid=36271
View this thread: http://www.excelforum.com/showthread...hreadid=562399