The purpose of the Convert Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your data contain and set the column data format.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Microsoft Excel’s AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can’t change the size of a cell to fit the text ...