merge text togther and add a space between each text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
hi.
this is access not excel.
assuming you have text in a1 and b1 then in c1 put
=concatinate(A1," ",B1)
 
Back
Top