Use this quick and easy tip for… Custom #PAYROLL REPORTS… Preparing BUDGETS…Adding another data source to your CUSTOMER DATABASE (CRM).
CONCATENATE is by far my most used and absolutely one of my top 3 favourite formulas. It makes customising data so much easier.
Simply, the Concatenate formula joins text and numbers, separated by a comma.
The exciting part is that within the Concatenate formula, you can include other formulas like LEFT, UPPER, ROUND.
PLUS!!! You can ADD extra characters too.
You really can go crazy with this formula. Start using it today!!