Concatenation Function

[adn4n]

Hi i have a problem with the concatenation function, everytime i try t
put A1 and B1 together the text strings have no same in between.

I have James in cell A1, and Phillips in cell B1. I concatenated this.
therefore it gave me an output of JamesPhillips (both words together
no space) i would like to have a space as this would make more sens
rather than having the first and last names of a person together. Ca
anyone please help. regards

 

[Chip Pearson]

Use something like

=A1&" "&B1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dthmtlgod]

try

= concatenate(a1 & " " & b1)

 

[Frank Kabel]

Hi
try
=A1 & " " & B1

 

[Eamon]

Try this:

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

Should give you 'James Phillips

 

[Frank Kabel]

Hi
no need for CONCATENATE in your formula as you already
concatenate the cell values within the bracktes

 

[Alan]

=A1&" "&B1