Try DataText to columns

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Adam" wrote in message
...
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