columns

  • Thread starter Thread starter Daphtg
  • Start date Start date
D

Daphtg

how do you combine column content as in number in address and street name?
 
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 &.
 
You must log in or register to reply here.

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

Similar Threads

Match Account ID from combining street names and numbers 1
How to combine two columns into a new column 2
combining column content 8
Word Create a Phone Book using MailMerge in word 2007 0
How do you alphabetize street addresses within a column? 1
How do I combine the contents of two columns? 4
text to column 6
Seperating Text from Numbers in a cell 13

Back
Top