Excel: Remove characters after a space

Quickly... here's an example of what you're looking for

 I have this string in cell B2

1000FRA150-G54 90D 12'

with this version of the formula, I'm returning the the text before the blank space

=LEFT(B2,FIND(" ",B2,1)-1)

Result: 1000FRA150-G54

with this version of the formula, I'm returning the text after the blank space

=RIGHT(B2,(LEN(B2)-FIND(" ",B2,1)))

Result: 90D 12'

Read More

Find more at <http://www.ozgrid.com/forum/showthread.php?t=28709>