Importing files

S

stina

I'm trying to import a file that has everything in A1

I've tried using a delimeter for tabs and spaces to help sort through
everything, however it just doesn't work well. Because I used spaces, it
separates addresses, and so the columns do not match up with one another.
However If I do not use spaces, it uses only column A to separate the fields.

I'd really appreciate any help someone can offer me on this, it's for SAT
scores, and it would be very helpful.
 
E

exceluserforeman

Do you mean to import the file and put it into A1 only?
This could lead to disastrous results.
 
S

stina

yes, that's exactly what it does, unless i use a tab delimiter, and then it
does it A1 holds miles of information and then for the next student, B1 holds
tons of information.
 
P

Pete_UK

If it puts the data in cells going across the sheet, then what happens
if you have more than 256 students? If you don't have this many, then
you can transpose the data so that it appears in column A only -
highlight the cells from A1 to however many you have on row 1, click
<copy> then move the cursor to A3 (for example) and Edit | Paste
Special | Values (check) and check Transpose, then OK and <Esc>. You
can then delete row 1.

You could then think about separating the data out into separate
columns - Data | Text-to-Columns might work if you have some character
to use as delimiter, or you might have to develop some formulae
including LEFT, MID, RIGHT etc to split the data up - it would help if
you posted 2 or 3 examples of the data you have at the moment.

Hope this helps.

Pete
 
Top