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