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

Doman wrote:
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

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

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

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

Regards
Special-K


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562399

Thanks for the solution! Easy and handy


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