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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtract text after the third space and before the fourth (from between spaces) 3
Split column contents (de-concantenate) 7
Email Merge Cell Formatting 2
Mail merge 4
StreamWriter.WriteLine and ConsoleWriter.WriteLine Question tia sal22 2
Rich Text Format 0
Start Each Year on New Page 2
VBA: Merge text boxes 0

Back
Top