columns

  • Thread starter Thread starter Daphtg
  • Start date Start date
You can combine text (know as concatenating) from two cells (A1 and B1 for
this example) like this...

=A1&" "&B1

Notice concatenated a space in between the text from these two cells in
order to separate them. If you leave that out...

=A1&B1

the text from the two cells will butt up against each other. You can
concatenate multiple cell values and text constants in any order you want.
 
Hi,

=A1&", "&B1

This would concatenate the contents of A1 and B1 in a new cell with a comma
and a space between them.

There are few if any reasons to use the CONCATENATION function instead of &.
 
Back
Top