The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.

Because there are hundreds of functions to choose from, Excel groups functions into categories to make it easier to find the right function for a particular calculation.

Q. I have several product numbers that each appear in a single cell in Excel. Each product number contains the product line (the first three digits), the product color (the middle four digits), and ...

The function should look something like this: "RIGHT (B2,4)." Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters.