Forum Discussion
swaraj swaraj mahimaprasad
Jul 06, 2018Copper Contributor
how i add space while combining text from 2 cells using concatenate
I am trying to combine text from 2 cells using concatenate. However I am unable to include a space between the 2 text or give a comma
2 Replies
- =A1&" "&B1, or =CONCATENATE(A1," ",B1)
- swaraj swaraj mahimaprasadCopper Contributor
Thank you so much!!