Question: If I have two cells,

A1 has the world Hello, A2 has the word World.

So if I type into another cell, =A1&A2 I will get HelloWorld

I would really like to know what day it is too,

So I tried to type in =A1&A2&NOW() but the output is, HelloWorld44728.5556479167

I have also tried, =CONCATENATE without success.

Answer: 
It's done just like under, or at least close to, win 10.

* Open "Settings" and navigate as follows
* Time & language
* Typing
* Advanced keyboard settings
* Input language hot keys".

This should open a window called "Text Services and Input Languages" it should contain an "Advanced Key Settings" section where you can switch between the two modes of how to turn off Caps Lock.
I find that a lot more comfortable as well and is usually one of the first things I change when setting up my profile after a fresh windows installation.
> 
> On my old computer, when caps-lock is activated and I press the shift
> key, it disables the caps look.
> 
> 
> 

That is most likely a function of BIOS in the old computer and is not standard behavior on any computer I have (or have had).

So you will need to use the Caps Lock key to both toggle Caps ON and then OFF. - This is quite normal.