It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions.