Learn how to split full names in Excel spreadsheets. When you have a worksheet with a column of full names, or have imported a document that puts full names in just one column,…
Introduction
Named Ranges in Excel
Learn to create named ranges in Excel spreadsheet to generate the sum of a range of numbers. This is useful when you are working with multiple numbers that you want to total up,…
Format Social Security Numbers
Learn how to format social security numbers in Excel spreadsheets by adding the appropriate dashes in the numbers to make them easier to read. When importing data such as social security numbers, they…
Get the Largest Number in Range in Excel
Learn to get the largest number in Excel spreadsheets using a simple formula. Excel allows you to select a range of cells and from there, will find you the largest number. This is…
Get the Smallest Number in Excel Spreadsheet
Learn to get the smallest number in Excel worksheets. There is an easy formula that will retrieve the smallest number in a range of cells in Excel for you. This is helpful when…
Remove All Decimals in Excel
The process to remove all decimals in Excel worksheets is easy and only requires a formula to accomplish. The process of changing decimals numbers to truncated numbers is helpful when you are tired…