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.