Concatenation

J

jknapp1005

I am trying to use the Concatenate function to join two columns of text. How
do I get a space between what I'm trying to concatenate?
 
M

Michael

If you are using the ampersand:

=A1&" "&B1

The blank space goes in between quotes, I placed 2 spaces to make it more
obvious.
 
C

Chip Pearson

Concatenate works only with single cell values. You can use

=CONCATENATE(A1," ",B1)

However, you cannot do something like

=CONCATENATE(A1:B10)

CONCATENATE doesn't work in array functions. Indeed, there is really
no reason to ever use the CONCATENATE function. You can do the same
thing with less typing by using the & operator:

=A1&" "&B1

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

Concatenate cells with line breaks in them 4
Delimiters in Text to Columns 0
Formula to add two spaces into a number stored as text 4
VLOOKUP source values are a formula result. Getting #N/A 7
Lookup against concatenated source value 4
Generating Functions with "Concatenate" 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Constructing Range Name calls with Concatenate 4

Top