merge text togther and add a space between each text

E

epeltcs

I orginally used the text to columns to seperate the text. Then I used
concatenate but the text is string together. I want to merge the text
togther using a space in between the text.
 
G

Guest

hi.
this is access not excel.
assuming you have text in a1 and b1 then in c1 put
=concatinate(A1," ",B1)
 
Top