New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
Get the latest from WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a Tangent Line with Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel inventory template with running totals
How To:
Remove empty space when converting an Excel file to a PDF document
How To:
Calculate interest rate risk in Microsoft Excel
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Graph the probability density function in an Excel file
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Find range and interquartile range in Microsoft Excel
How To:
Find & extract duplicate records from a data set
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a Tangent Line with Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel inventory template with running totals
How To:
Remove empty space when converting an Excel file to a PDF document
How To:
Calculate interest rate risk in Microsoft Excel
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Graph the probability density function in an Excel file
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Find range and interquartile range in Microsoft Excel
How To:
Find & extract duplicate records from a data set
Be the First to Comment
Share Your Thoughts