Concatenation...

  • Thread starter Thread starter Silas
  • Start date Start date
S

Silas

Hi. I'm using the CONCATENATE function to combine text from two cells but I
need a space between the entries. I've tried hitting the space-bar and also
putting the space in quotes. Nothing works. I'm using Excel 97.

Thanks.

Silas
 
Silas

one way:

=CONCATENATE(B1," ",C1," ",D1)

or:

=B1 & " " & C1 & " " & D1

Regards

Trevor
 
You must log in or register to reply here.

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 Concatenate with line breaks but ignore blank cells 3
Macro - searches for key word in a column and concatenates entire 6
Concatenate values 4
How to delete commas and spaces when not needed ... S&R way, or macro way? 11
Concatenate cells from M9 to Last row in M 2
Rich Text Format 0
Combine two cells without losing data cell formats 2
Odd behavior using CONCATENATE 4

Back
Top