ACBA (UK) LTD worksheet functions concentrate mainly on the problems associated with extracting and using numbers contained inside strings. However the full range of functions covers

• identifying approximately equal numbers
  
• comparing the presence of numbers within strings
  
• extracting number values direct from strings
  
• extracting number values (and other data) from number arrays derived from strings
  

In this section we also consider the strengths and weaknesses of using Worksheet Functions..

Each of the descriptions in this section takes a standard format

• Name, description and data-type of the Function
  
• Name, role or function and expected data-type of each of the arguments
  
• A worked example using Excel's standard 'Function Arguments' user interface.
  
• An explanation of error values (if any)
  

For the majority of the ACBA user defined worksheet functions there are also equivalent user forms for analysing data lists of strings. These cover

• extracting numbers form strings,
  
• deriving information from number arrays. and
  
• a discussion of the advantages of using the list analysis dialogs over worksheet functions