Get actual worksheet functions list
Code:let Source = Web.Page(Web.Contents("https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188")), Data0 = Source{0}[Data], Clean = Table.TransformColumns(Data0,{{"Type and description", Text.Clean, type text}}), Split = Table.SplitColumn(Clean, "Type and description", Splitter.SplitTextByEachDelimiter({":"}, QuoteStyle.Csv, false), {"Type and description.1", "Type and description.2"}), Replace = Table.ReplaceValue(Split," ","#(lf)",Replacer.ReplaceText,{"Type and description.2"}), Trim = Table.TransformColumns(Replace,{{"Type and description.2", Text.Trim, type text}}), Replace2 = Table.ReplaceValue(Trim,",","#(lf)",Replacer.ReplaceText,{"Type and description.2"}), Ren = Table.RenameColumns(Replace2,{{"Type and description.1", "Type"}, {"Type and description.2", "Description"}}), Index = Table.AddIndexColumn(Ren, "Index", 1, 1), Reorder = Table.ReorderColumns(Index,{"Index", "Function name", "Type", "Description"}) in Reorder
part of data:
Index Function name Type Description 1ABS function Math and trigonometry Returns the absolute value of a number 2ACCRINT function Financial Returns the accrued interest for a security that pays periodic interest 3ACCRINTM function Financial Returns the accrued interest for a security that pays interest at maturity 4ACOS function Math and trigonometry Returns the arccosine of a number 5ACOSH function Math and trigonometry Returns the inverse hyperbolic cosine of a number 6ACOT function Math and trigonometry Returns the arccotangent of a number 7ACOTH function Math and trigonometry Returns the hyperbolic arccotangent of a number 8AGGREGATE function Math and trigonometry Returns an aggregate in a list or database 9ADDRESS function Lookup and reference Returns a reference as text to a single cell in a worksheet 10AMORDEGRC function Financial Returns the depreciation for each accounting period by using a depreciation coefficient 11AMORLINC function Financial Returns the depreciation for each accounting period 12AND function Logical Returns TRUE if all of its arguments are TRUE 13ARABIC function Math and trigonometry Converts a Roman number to Arabic
as a number 14AREAS function Lookup and reference Returns the number of areas in a reference
and so on ...
Bookmarks