Forum Discussion
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
=A1&" "&B1, or =CONCATENATE(A1," ",B1)
Thank you so much!!