| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from multiple cells into one cell.
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining data from multiple cells into one cell.
=concatenate(C4," ",D4) "Steelsilk" wrote in message ... 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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining data from multiple cells into one cell.
=(C4&""&D4)
"RFJ" wrote: =concatenate(C4," ",D4) "Steelsilk" wrote in message ... 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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining data from multiple cells into one cell.
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? "Steelsilk" wrote: 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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining data from multiple cells into one cell.
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 On Thu, 17 May 2007 05:31:03 -0700, Steelsilk wrote: 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Most efficient formula/combining multiple data cell ranges/seperat | New Users to Excel | |||
| Combining Data from Multiple Columns | Excel Worksheet Functions | |||
| Combining Data multiple tabs | Excel Discussion (Misc queries) | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Hybrid Mode
