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
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