combining cell entries

[rjz]

I remember having read a simple formula for combining the entries in
cells (be it text or numbers), so that the result shows in another
cell.
Example: cell A1 has Lotus and cell A2 has 123 The formula placed in
let us say cell C5 delivers me : Lotus123

It was very simple but i cannot find it anywhere

Please help!!

 

[J.E. McGimpsey]

One way:

Use the concatenation operator:

=A1 & A2

another: use the Concatenation Function:

=CONCATENATE(A1,A2)