space between text strings with concatenate

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I'm using the concatenate function to join two bits of text - but I want a
space between, and the function joins them together without a space. How
can I insert a space into the resulting text please? (It seems to me that
we would want such a space in ANY two text strings which we join together
with concatenate - wouldn't we?? Why doesn't it put one in by default?!)

Thanks
Jeff
 
CONCATENATE is a worthless function. You can join text
strings using the ampersand (&). To add a space, use:

=A1&" "&A2

HTH
Jason
Atlanta, GA
 
Back
Top