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