columns

R

Rick Rothstein

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.
 
S

Shane Devenshire

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 &.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top