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?
insert a space between the two strings. How do i do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JulieD
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
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
A
Andy B
Gordon.
One way:
=A1&" "&A2
Andy.
One way:
=A1&" "&A2
Andy.
F
Frank Kabel
Hi
try in C1
=A1 & " " & B1
try in C1
=A1 & " " & B1
A
Andy B
Gordon
If you want to stick to using CONCATENATE, try:
=CONCATENATE(A1," ",A2)
Andy.
If you want to stick to using CONCATENATE, try:
=CONCATENATE(A1," ",A2)
Andy.
N
Niek Otten
=A1&" "&B1
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
G
Gordon
-----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?
.
Thanks for the fast info guys!