| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging of cell content i a Worksheet
Hi!
I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging of cell content i a Worksheet
In cell D1, place something like below to merge A1,B1, and C1
=A1 & B1 & C1 If you want spaces: =A1 & " " & B1 & " " & C1 Morten wrote: Hi! I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging of cell content i a Worksheet
In B1 enter... =C1&D1&E1 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Morten" wrote in message Hi! I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging of cell content i a Worksheet
Thanks
-- MarMor "JW" wrote: In cell D1, place something like below to merge A1,B1, and C1 =A1 & B1 & C1 If you want spaces: =A1 & " " & B1 & " " & C1 Morten wrote: Hi! I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging of cell content i a Worksheet
Thanks
-- MarMor "JW" wrote: In cell D1, place something like below to merge A1,B1, and C1 =A1 & B1 & C1 If you want spaces: =A1 & " " & B1 & " " & C1 Morten wrote: Hi! I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging of cell content i a Worksheet
Hi Morten,
For the future, if you have a lot of these to do in entire columns and don't want to mess with cleaning off worksheet formulas when done you might want to use a macro if it fits your needs (puts a space in between for each cell's te4xt it annexed). http://www.mvps.org/dmcritchie/excel/join.htm#join I realize the thread is two weeks old, and you got answers you could use with worksheet formulas. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Morten" wrote in message ... Hi! I wonder if there is an easy way to merge the contents of 3 cells into one cell? -- MarMor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Merging cell content with a comma seperattor | Excel Worksheet Functions | |||
| Using cell content to access another worksheet in same workbook | Excel Worksheet Functions | |||
| HELP: How to Repeat Cell Content into a Second Worksheet ? | Excel Worksheet Functions | |||
| Link content from dialog box to a worksheet cell | Excel Discussion (Misc queries) | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Linear Mode
