Remove everything right once a space is countered (variable length text to left needed)

[JET2011]

Remove everything right once a space is countered (variable length text to left needed)

Example; Column A includes serial numbers of variable length typically 4 - 14 in length followed by a space or two then comments. None of the serial numbers have imbedded spaces. I only need the serial number and want to trim all to the right INCLUDING the space.

Column A Data example:
truck-101 Nice color, low miles
bike-12345687 slight wear but solid

Desired Result
truck-101
bike-12345687

Thanks for any direction, hopefully non programming solution may be found.

Best jj

[PaulM100]

This should work:
=LEFT(A2,FIND(" ",A2)-1)

[JET2011]

This site is great, thanks PaulM.

This does exactly what I want but I don't know how to get the resulting data posted to another column as values only (not tied to the formula.)

When I copy and paste as values only into another column it picks up spaces to the right. How do I get around that, however this is workable.

Regards,

jj

[PaulM100]

Change it to:

=TRIM(LEFT(A2,FIND(" ",A2)-1))

[JET2011]

The original formula was equally effective as this one, thank you Paul, my issue is getting the resulting data without trailing spaces into another column that is not
formula dependent.

Regards,

jj

[PaulM100]

I am a bit unclear. The TRIM function does that. Maybe you have non breaking spaces. Try this:

=substitute(TRIM(LEFT(A2,FIND(" ",A2)-1)),char(160),"")

[AlKey]

In case you do have a non-braking character (char 160) use this

Please Login or Register  to view this content.

[JET2011]

That's perfect!! Would not have figured that our ever. It was key to get the spaces out as the resulting data is later compared to other data that does not have spaces so the matches would be missed.
Thanks Paul and AlKey

-jj