These functions replicate the equivalent user-defined worksheet functions at Numbers inside Strings - formulae. Instead of using single formula these functions are accessed via a dialog box from the main ACBA Tools Menu bar and extract the number data required from a data list of string values. The results are also listed in a column to the immediate right of your data list. The column header acts as an audit trail. It reports both the process used and the parameters employed.

The ACBA Audit Tools package provides two approaches to extracting numbers from strings. This section deals with the approach that is simpler and where the results are available directly.

These functions are split into two categories

• Extracting the numbers from a string
  
• Finding out about the numbers contained within a string - Miscellaneous
  

Remarks

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also

User Forms vs Worksheet Functions | User Tools