One way

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

copy down, when you are done copy the range and then do editpaste special
as values if you want the result to be independent of the data


--
Regards,

Peo Sjoblom



"terri" wrote in message
...
We have a problem. We have a long string of data that had sections
separated
by spaces. We want to pull out the first section and the third section.
Problem is there not all the same length. Example below

B360N V ORB 505 123
FB350N V FLA 505

So we want to pull out the B360N and the FB350N and the ORB & FLA into two
columns.

Does anyone have any suggestions --

We can do in access or excel?