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 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.