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.
|