Have you tried Data / Text to columns with Tab as the delimiter?
Otherwise - if you really have spaces and not tabs youare going to have to
use left, right, mid and find to pull out the data

"Gareth Wretham" wrote:

Any idea how I would separate out the following into cells for a stack
of data?

It is currently in the format :

378265 COMPANY NAME Broker LOCATION 667050 TTL

and I want to separate out where I have added the ¦

378265 ¦ COMPANY NAME ¦ Broker ¦ LOCATION ¦ 667050 ¦ TTL

LOCATION and Broker are the same across all entries. The other data is
unique across entries.

There are no commas.