I have it done, but it isn't very clean. I'm looking for a better way to get the specifics of what I want. This is for the schools program I was asking about yesterday. So this is what I am looking for...

******Desired output
School Code | School Name | Addr1 | Addr2 | City/State| Zip


But, the imported data comes like this...

*****input
School Name | Addr1 | addr2
|city/state/zip | city state zip

So, it takes up two rows.

What I did was used the columns to the right of the imported data and just kinda copied them over. Like a new column for school name where it equals the column it is already in. Then to separate the city and state/zip stuff I used something like this...=LEFT(C3,LEN(C3)-SEARCH(" ",C3,1)) where C3 is the city/state/zip cell under addr1 from the imported data. So it theoretically pulls the city out and puts it in a nice spot after adder2(see above example of desired output). This works for the most part with the city, but there are occasional errors where it only picks up half the name or whatever. The real problem is with the zip code. Some are 5 digit and some are the 5-4 style. So it is pretty inconsistent on giving me a nice zip code. Also, after I have it all set up the way I want I have another major problem. I want to export the output I want, but how do I do that without also exporting the input data that I no longer want without ruining the references with the output I want. Also hiding that extra row leftover from the input data, because when I organize my output it is all on one row, but it uses that city/state/zip stuff from the 2nd row of input.

Sorry, this is quite a long and convoluted post. I hope it made enough sense for someone to help me. I am very grateful for whatever ideas you have.