Dec 15, 2021

Excel Tips and Trick

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")


Listing Source


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 + 


But, the result look perfect, we need space using double comma " " with space, as picture in below