How To: Make an Excel PivotTable year category from text dates

Make an Excel PivotTable year category from text dates

How to Make an Excel PivotTable year category from text dates

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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest