I'm very, very new to macros and coding.

So, I need help!

About the data and my spreadsheets:

1. All the data is in Column A
2. The data is space delimited
3. The spreadsheets are quite large. Column A may have anywhere from 500,000 to 1,000,000 cells populated
4. I have over 100 spreadsheets

Is there a way to have a macro or a code I could run to do the following to all the spreadsheets?

1. Take all the data in Column A and separate it into the adjacent columns ('Columns to text'?)
2. Insert 10 columns before Column A? That would mean that the data in Column A would then move to Column K...
3. Insert a function of my choice into all the cells in Column J? Which would calculate values based on the values in the adjacent columns...
4. Insert another function into all the cells in Column Z? Which would also calculate values based on the values in the (latter) adjacent columns...

I'm, of course, trying to do all of this without opening up each spreadsheet individually...

Please let me know! Thanks!