Excel Forum



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.