separating data from imported txt file into cells

  • Thread starter Thread starter Gareth Wretham
  • Start date Start date
G

Gareth Wretham

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import stock prices from discount broker acct 2
Formula to correct copied option tickers starting with "+" 4
SQL Server dataset read from database A and write to database B 2
Importing Txt file into Excel 9
Importing a Text File Into 1 Column 14
Separating data in the same cell 1
Import data from multiple txt files into one xls file 3
Macro that will insert a simple text string in top cell of text file 1

Back
Top