View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default concatenate formula

Hi,

And if you are using the longer version
=CONCATENATE(A1," ",B1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tacklemom" wrote:

Hi there,

I am wondering how to include spaces in this formula. I am joining 2 cells
but want 2 blank spaces between the joined cells. Thanks
--
Donna