How to Abbreviate Days in Excel Method 1 – Using the TEXT Function In E5, enter the following formula: =TEXT(D5, “ddd”) Press ENTER >> use the Fill Handle. The names of the days are abbreviated. Method 2 – Combining the CHOOSE & WEEKDAY Functions In E5, use the following form...