Well, now you already know how to get the '&' symbol. I am going to show you the use of this symbol.
See, easy to understand right? However, the sentence does not make sense unless you put spaces between the words right? By adding this " " you can put spaces between those words. Here's how:
There is also a formula to this which is called concatenate, =concatenate( ). Yeah as straightforward as it sounds, it is easy to use.
How useless it might seem, don't ever underestimate the use of '&'. It is very useful when it comes to reconciliation which need two criteria to match because of the first criteria has the same figure/text/whatsoever with another set of data.
For example, recurring payments in your bank reconciliation, if you are doing reconciliation for few months you might end up with few payments, apart from the rest of the payment which has the same amount but different date.
So & can be used with the amount & date to match against what you have in your system.
Anyway, Happy trying. :)
