| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I combine text from several cells into one?
Is it possible to combine the text in one Excel cell to another cell in the
same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine text from several cells into one?
have you looked at "concatenate" in Excel help?
-- Gator "Michael" wrote: Is it possible to combine the text in one Excel cell to another cell in the same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine text from several cells into one?
Hi Michael
In the destination cell type =A1&" "&B1&" "&C1&" "&D1 this assumes you want a space between each item. If you wanted a comma, use "," If you do not want a separator just use =A1&B1&C1&D1 -- Regards Roger Govier "Michael" wrote in message ... Is it possible to combine the text in one Excel cell to another cell in the same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine text from several cells into one?
type = then click the first cell then "&" and the next cell and so on. If you
need a comma or something just put it in quotes between &'s such as =A1 & ", " & A2 -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Michael" wrote: Is it possible to combine the text in one Excel cell to another cell in the same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine text from several cells into one?
Michael
In F1 enter =A1&B1&C1&D1&E1 If you want spaces between enter them as.......... =A1& " " & B1& " " & etc. Gord Dibben MS Excel MVP On Tue, 16 Jan 2007 10:08:01 -0800, Michael wrote: Is it possible to combine the text in one Excel cell to another cell in the same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine text from several cells into one?
Thanks for the help everyone!!!
Gord Dibben wrote: Michael In F1 enter =A1&B1&C1&D1&E1 If you want spaces between enter them as.......... =A1& " " & B1& " " & etc. Gord Dibben MS Excel MVP On Tue, 16 Jan 2007 10:08:01 -0800, Michael wrote: Is it possible to combine the text in one Excel cell to another cell in the same row? I need to combine the text of four or five cells into one cell which would then contain the all the text of the other cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I fill a series in Nonadjacent cells eg Text 1, Text 2 | Excel Discussion (Misc queries) | |||
| Combine text data from 2 cells | Excel Discussion (Misc queries) | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
| combine the text or digit in different cells | Excel Discussion (Misc queries) | |||
Linear Mode
