Hello,
I am using =CONCATENATE(A2&"",B2&"",C2&"",D2) and for some reason the spaces between the words won't appear.. below is what I get and what I need.
Thanks in advance,
JJ in SD
I am using =CONCATENATE(A2&"",B2&"",C2&"",D2) and for some reason the spaces between the words won't appear.. below is what I get and what I need.
Thanks in advance,
JJ in SD
Spreadsheet for Newspaper ADS.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | I | am | trying | to | put | a | space | between | the | words | ||
3 | ||||||||||||
4 | Iamtryingto | |||||||||||
5 | ||||||||||||
6 | Iamtryimgtoputaspacebetweenthewords | |||||||||||
Sheet1 |