In Excel, Modes can be arrays, numbers, names, or suggestions that contain numbers. The Mode function ignores values such as text, logical values, or empty cells in an array or reference argument.

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.