Hello,
I just joined, and am looking for some help with a problem I have.
I very rarely work in Excel (I’m an animation artist), so I am perplexed by much of it.
But I have a new animation project which is using an Excel spreadsheet to automatically fill some text fields in a template I’ve built in Adobe After Effects.
The After Effects script I am using imports data from a spreadsheet saved in the Tab Delimited Text format.

My problem is this. Because of how the imported text is formatted within After Effects, I need to add some spaces to the beginning of a cell (A2) that contains text. The number of spaces to add is dependent on the length of a text string in a different cell (A1).

I have figured out how to find the number value of (A1) by using =LEN(A1) in a blank cell.
But I can’t figure out how to apply the resulting value, adding that number of spaces at the beginning of (A2).

I found this post http://www.excelforum.com/excel-gene...n.html http:// which seems to contain a working solution, however I have no idea how to apply that solution to my spreadsheet.

If my post isn’t clear, let me know and I can try to fill in the blanks.
As I said, I almost never use Excel, so I am an ultra-noob.

Sorry, almost forgot to mention, I’m using Office for Mac 2011.

Thanks for any help.
Mark