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!

[Special-K]

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

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

Regards
Special-K

[Bondi]

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

[Doman]

Thanks for the solution! Easy and handy