combining cell entries

  • Thread starter Thread starter rjz
  • Start date Start date
R

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!!
 
One way:

Use the concatenation operator:

=A1 & A2

another: use the Concatenation Function:

=CONCATENATE(A1,A2)
 
Back
Top