This form has two parameters

• the column address of the datalist you want to analyse (choose a letter from the dropdown text box)
  
• the specific analysis to be performed (select one of the four options)
  

The result is posted in the first column to the right of the list range. The column header show the analysis performed and the column that held the string values.

These functions have no error values. The absence of a number at the beginning or end of a string is equivalent to 0 (zero).

Remarks

The form evaluates the range surrounding the active cell, and delivers that as the active range for analysis. If the cell is empty or the list range appears too small, the user will receive a warning.

See also

Numbers inside Strings - Form Based | Extract Number