How To: Extract digits to the right of a decimal in MS Excel

Extract digits to the right of a decimal in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.

Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard

Life Hacks for Your Smartphone

Fresh tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest