View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MtK MtK is offline
external usenet poster
 
Posts: 1
Default trying to combine cells with shortest equation

So I have this equation that looks like

=C1&" "&C2&" "&C3&" "&C4&" "&C5

I was thinking maybe I could reduce the equation to just show the
first and last cell like =C1:C2 but that doesn't work and even if it
did i need the space between the two cells. and help are creating a
reduced equation that uses the first and last cells and has a space
would be greatly appreciated. thanks.