There could be times during your daily workflow when you may want to combine 2 columns in Excel with a space. Let’s say you have first names in one column and last names in another. Now, instead of ...

Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data, such as numbers and text, increasing the width ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...

How to conditionally count the number of times any value occurs in Excel Your email has been sent Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make ...

How to count individual cells within a row by their fill color in Excel Your email has been sent The article How to easily sum values by a cell’s background color in Excel shows you an easy way to ...

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...