Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

There are a number of different ways that you can display formulas in Excel. This can be useful when investigating why a certain formula isn’t working correctly or when grading your students’ ...

Q. Is there a way to include both a formula and text in the same cell? A. You can include both a formula and text in the same cell in Excel. You can do this in many ways, depending on what you are ...

If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.

Excel Keystrokes Open the Excel 2010 program to display a new worksheet or open a saved worksheet. Click the cell where you wish to insert the bulleted text. The selected cell displays a black ...

Text wrapping isn't just for word processors. You can wrap text in spreadsheets too. Here's how to wrap text in Microsoft Excel using two different methods.

To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data.

In one of the Excel sheets from work I noticed it had a name that was in kanji and it was being displayed as gibberish so I just tried other CJK character sets and it seems that Excel 2011 can't ...