Monthly Archives: March 2016
How to round the values in a range of cells in Microsoft Excel?
Assume that you have a range of cells that contains values with 4 decimal places and you wish to round their values to 2 decimal places in Microsoft Excel 2016. How to round the values in a range of ...
How to Export Data to Text file in Microsoft Excel 2016?
If you need to export the worksheet data to a text file in Microsoft Excel 2016, you can do that easily using the Save As command. How to Export Data to Text file in Microsoft Excel 2016? 1. Open you...
How to swap the cell contents quickly in Microsoft Excel ?
Here’s a simple trick that lets you to swap the contents of the cell quickly in Microsoft Excel 2016. How to swap the cell contents quickly in Microsoft Excel ? 1. Enter the value 11 in cell B1...
How to limit the number of characters in a cell in Excel?
There are times when you might want to prevent the users from entering certain number of characters in a cell in Excel. For example , you might have a mobile number column and you want to limit the c...
Split the Full Name to First Name and Last Name in Microsoft Excel 201...
This blog will explain how to split the column that contains the full name to first name and last name in Microsoft Excel 2016 using the Text to Column command. How to split full name to first and la...