Combining data from multiple cells into one cell.

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

Guest

I have looked this up in the help section. The instructions and the example
are not the same. I have tried several variations of both but I'm still not
getting the results. Any help is greatly appreciated. I have included some of
the formulas that I've tried.

=(C4&" "&D4) from the instructions
=C4&" "&D4 from the example
=(C4,&" "&D4)
=(C4&"&D4)
 
The one from the instructions and from the example should work for you. What
do you get when you enter those formulas? an error message?
 
What results do you want?

Either 1 and 2 formulas will do the trick.

C4 contains qwerty
D4 contains asdfgh

=C4&" "&D4 returns qwerty asdfgh


Gord Dibben MS Excel MVP
 
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

change cell color depending on two cell values 1
Timesheet formula problem 2
How do you calculate a negative percentage 2
someone please shorten this formula... 6
Excel Formula Formatting 3
Transfer data from a cell to another workbook if certain criteria 14
Excel Formula Formatting - How to Add a STOP Statement 4
How do I include names in formula by picking up names from rows 6

Back
Top