Apply LEN result to string?

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
.

Relevant Pages

  • Re: help collecting data.
    ... Dim GetC As String ... the code in the cell that I want the order numbers(info from column C ... "Otto Moehrbach" wrote: ... display them both, seperated by a comma ...
    (microsoft.public.excel.misc)
  • RE: Create a "cell button" to hide selected cells.
    ... What I'd like to do, however, is to select a range of columns to display so I ... Dim intPickMonth As Integer ... Create a ComboBox on Cell A1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Displaying formulae changes formatting
    ... "macropod" wrote: ... result for a given cell. ... With the macro I posted, you can display both the formula and it's result, ... Set CommentRange = Range ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Email Booster from Excel
    ... You can use Display instead of Send and then attach the file you want. ... Dim cell As Range ... Set OutApp = CreateObject ... 1.Instead of yes/no in criteria I wanted have it compared with date if the date and time matches to todays date and time then "yes" else no. ...
    (microsoft.public.excel.programming)
  • Re: How do I get just 1 cell to display its formulae not whole sh
    ... This little macro may do what you want. ... display the worksheet. ... Press Alt-F11 to go to the code editor. ... For Each cell In Selection ...
    (microsoft.public.excel.worksheet.functions)