Microsoft Excel
Inserting current date and time
Section titled “Inserting current date and time”Hit Ctrl + ; to add the current date
Hit Ctrl + Shift + ; to add the current time
Functions
Section titled “Functions”String functions
Section titled “String functions”SUBSTITUTE
Section titled “SUBSTITUTE”SUBSTITUTE(text,old_text,new_text,instance_num)
text is the text or the reference to a cell containing text for which you want to substitute characters.
old_text is the text you want to replace.
new_text is the text you want to replace old_text with.
instance_num specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num,
only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.
ISBLANK
Section titled “ISBLANK”checks whether a cell is empty