Excel Tricks to Instant Sequential Lists Typing “Day 1” to “Day 365” manually is slow and outdated. Modern Excel makes this effortless with the SEQUENCE function. In this Excel Tutorial we’ll explore Sequence function. Use this formula to generate a full day list with both text and numbers: ="Day "&SEQUENCE(365,1) Excel automatically combines the text “Day ” with numbers 1 to 365, creating Day 1, Day 2, Day 3… Day 365 instantly. SEQUENCE(365,1) generates the numbers, and adding "Day "& in front

Fixed Messy Data by using PROPER & TRIM function/formula in Excel !! ✅Formula: =PROPER(TRIM(A2) ✅Syntax: =PROPER(TRIM(Select the cell range) ✅Used TRIM function to remove unwanted space form the data. ✅Used PROPER function to change case into proper case from messy text format. #exceltipsandtricks #exceltips #tutorial #tipsandtricks #VirtualAssistantPortalPH | Virtual Assistant Portal PH | Facebook