Maybe not be understanding, but take a look at
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"RAP" wrote in message
...
Using LEFT formula and LEN result, I need to apply the result (8) in a new
LEFT statement and display the results in a cell.

I am getting the filename, removing the file extension, and want to apply
the formula result (which = # characters to display from original
filename),
and display in a new cell.

How can I apply my variables in a new LEFT statement?
Thanks,
Randy