Well, a couple of options.
First try the Data | Text to Columns feature. It's in the Data Menu.

Or, both of these formulas will adjust to the length of the data:

=RIGHT(B31,LEN(B31)-FIND(" ",B31))

=MID(B31,FIND(" ",B31)+1,LEN(B31)-FIND(" ",B31))

I've used these to separate first and last names where they are listed
Firstname Lastname.

tj

"Adam" wrote:

Is there an easy way to take a text phrase and parse it to extract the
seperate parts into individual cells? The Right, Mid and Left functions all
depend on the data being the same lenth, which is not true in the app I am
using.

The Mid with a Find works somewhat, but you cannot always make it work