separating data from imported txt file into cells
 

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.

separating data from imported txt file into cells
 

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.