Header Banner
WonderHowTo Logo
WonderHowTo
Discover the Best New iOS 18 Features
WonderHowTo Gadget Hacks Next Reality Null Byte
wonderhowto.mark.png
Gadget HacksNext RealityFood HacksNull ByteThe Secret YumiverseInvisiverseMacgyverismsMind HacksMad ScienceLock PickingDriverless
how to
Home
Microsoft Office

How to Remove the last two words from a column in MS Excel

Apr 16, 2010 10:43 PM
Excel spreadsheet showing text manipulation examples, including removing last two words and using SUBSTITUTE, MID, LEN, and LEFT functions.

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.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Excel spreadsheet showing text manipulation examples, including removing last two words and using SUBSTITUTE, MID, LEN, and LEFT functions.
Microsoft Office
how-to

How to Automatically Hide the Ribbon Menu System in Excel

Excel spreadsheet showing text manipulation examples, including removing last two words and using SUBSTITUTE, MID, LEN, and LEFT functions.
Microsoft Office
Forum Thread

How to Make a Simple Report Card Template in Excel

Comments

No Comments Exist

Be the first, drop a comment!