Hi!
I'm fairly new to Excel but I've wanted to learn how to do this for a while.
The situation: I did a huge (!) data dump into Excel files a few weeks ago.
About the data:
1. The data is all dumped into Excel files.
2. The data is space delimited and all goes into the first column of a spreadsheet.
3. There are more than 100 files. Each is named Book2.xslx through Book149.xlsx
I have a few questions, but will tackle them one at a time so I can learn.
Question 1: Is there a way to add columns to each file 'remotely'?
That is, is there a macro, or any other way, that I can have every file, Book2.xlsx through Book 149.xslx, add 10 columns before Column A? That is, of course, without manually opening every single file manually?...
Question 2: Much the same, is there a way to do a 'Columns to Text' operation on Column A, remotely? Again, have the space-delimited data in Column A be inserted into the adjoining cells without opening every file manually?
Please let me know! Thanks!
Bookmarks