Excel Forum
Similar Content
Find the Last Column with Data in Excel VBA
Tutorial: How to find the last column in a row that has data. This includes selecting that column or...
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 393: Remove Last Two Words From Column Of Data


See how to remove last two words for column of data using LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions. Amazing formulas from Mr Excel Message Board.





Got a Question? Ask it Here in the Forum.