Duplicate
Ctrl + D
Fast input Date and Time
= Today( )
Ctrl + ; (Ctrl + Semicolon symbol)
Ctrl + Shift + ; (Semicolon symbol)
Change Date to Day
=TEXT(A2;"dddd")
Change English Day to Indonesia
=TEXT(A2;"[$-ID]dddd")
https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b
Vlookup
Combine Text-Text or Text-Number
Sometimes we need to combine text with text or text with number from other cells, but we usually using excel for calculating money or number, and in below as your solution.
- Firstly, use equal = , then click the cell and use & not +