Get Cell Number function

GetCellNumber returns numeric values it finds in an Excel spreadsheet.

Syntax

GetCellNumber (spreadsheet location, cell location)

Examples:

  • GetCellNumber ("C:\files\123.xls", "A3")
  • GetCellNumber (Q2, "D4") where Q2 is a lookup question that returns the file name of an Excel spreadsheet.
  • GetCellNumber (Q2, "Sheet1!D4") where Q2 is a lookup question that returns the file name of an Excel spreadsheet, and Sheet1!D4 defines the worksheet and cell location.