inserting a space in Concatenation

  • Thread starter Thread starter Gordon
  • Start date Start date
G

Gordon

I have two columns of text to concatenate. I want to
insert a space between the two strings. How do i do this?
 
Hi Gordon

option 1
=CONCATENATE(A1," ",B1)

option 2
=A1 & " " & B1

PS any text can be concatenated using either method as long as its enclosed
in " "

Cheers
JulieD
 
Gordon

If you want to stick to using CONCATENATE, try:
=CONCATENATE(A1," ",A2)

Andy.
 
-----Original Message-----
I have two columns of text to concatenate. I want to
insert a space between the two strings. How do i do this?
.
Click to expand...

Thanks for the fast info guys!
 
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

Concatenation 3
Concatenate 3
Concatenating two variable fields into a static length text field 2
Concatenate Question 4
Concatenate with a specific number of spaces 3
VLOOKUP source values are a formula result. Getting #N/A 7
How do I concatenate text that actually contains quotation marks? 3
Lookup against concatenated source value 2

Back
Top