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.
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Return the address of the 1st non-blank cell in Excel
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Automate tasks with macros in Microsoft Access 2010
-
How To:
Retrieve the name of a lowest-bidding vendor in Excel
-
How To:
Create a chart with two horizontal axes in MS Excel
-
How To:
Add drawings and free-form shapes in MS Word 2007
-
How To:
Add and subtract numbers with Excel's SUM function
-
How To:
Create a bond discount or premium amortization table in Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Group duplicates & extract unique records in MS Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Return the address of the 1st non-blank cell in Excel
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Automate tasks with macros in Microsoft Access 2010
-
How To:
Retrieve the name of a lowest-bidding vendor in Excel
-
How To:
Create a chart with two horizontal axes in MS Excel
-
How To:
Add drawings and free-form shapes in MS Word 2007
-
How To:
Add and subtract numbers with Excel's SUM function
-
How To:
Create a bond discount or premium amortization table in Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Group duplicates & extract unique records in MS Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Update inventory records by formula in Microsoft Excel
Be the First to Comment
Share Your Thoughts