| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to combine multiple cells into on cell
I need to combine multiple cells on one worksheet into one cell on another
worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
=Sheet1!A1&" / "&Sheet1!B1&" / " and so on
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
Follow this syntax:
=Sheet2!A1&" / "&Sheet2!B1&" / "&Sheet2!C1&" / "&Sheet2!D1 -- Biff Microsoft Excel MVP "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
='Sheet1'!A1&" / "&'Sheet2'!A1&" / "&'Sheet3'!A1&" / "&'Sheet4'!A1
You can use the & symbol to join cells/text strings. Note that text is entered using quotation marks. This formula, for example, returns the values of A1 from Sheets 1 - 4 with the forward slash seperating each value. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "papercut" wrote: I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
I entered the formula as follows (my sheet is named KGA):
=kga!L49&" / "&kga!L50&" / "&kga!L51&" / "&kga!L52&" / "&kga!L53&" / "&kga!L54&" / "&kga!L55&" / "&kga!L56&" / "&kga!L57&" / "&kga!L58&" / "&kga!L59&" / "&kga!L60 but a box is opening that says "Update Values kga". What am I doing wrong? Thanks, Leah "T. Valko" wrote: Follow this syntax: =Sheet2!A1&" / "&Sheet2!B1&" / "&Sheet2!C1&" / "&Sheet2!D1 -- Biff Microsoft Excel MVP "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
I entered the formula as follows (my sheet is named KGA):
=kga!L49&" / "&kga!L50&" / "&kga!L51&" / "&kga!L52&" / "&kga!L53&" / "&kga!L54&" / "&kga!L55&" / "&kga!L56&" / "&kga!L57&" / "&kga!L58&" / "&kga!L59&" / "&kga!L60 but a box is opening that says "Update Values kga". What am I doing wrong? Thanks, Leah "Luke M" wrote: ='Sheet1'!A1&" / "&'Sheet2'!A1&" / "&'Sheet3'!A1&" / "&'Sheet4'!A1 You can use the & symbol to join cells/text strings. Note that text is entered using quotation marks. This formula, for example, returns the values of A1 from Sheets 1 - 4 with the forward slash seperating each value. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "papercut" wrote: I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
I entered the formula as follows (my sheet is named KGA):
=kga!L49&" / "&kga!L50&" / "&kga!L51&" / "&kga!L52&" / "&kga!L53&" / "&kga!L54&" / "&kga!L55&" / "&kga!L56&" / "&kga!L57&" / "&kga!L58&" / "&kga!L59&" / "&kga!L60 but a box is opening that says "Update Values kga". What am I doing wrong? Thanks, Leah "Bernard Liengme" wrote: =Sheet1!A1&" / "&Sheet1!B1&" / " and so on best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
a box is opening that says "Update Values kga".
That usually means the referenced sheet doesn't exist. Maybe you've misspelled the sheet name? -- Biff Microsoft Excel MVP "papercut" wrote in message ... I entered the formula as follows (my sheet is named KGA): =kga!L49&" / "&kga!L50&" / "&kga!L51&" / "&kga!L52&" / "&kga!L53&" / "&kga!L54&" / "&kga!L55&" / "&kga!L56&" / "&kga!L57&" / "&kga!L58&" / "&kga!L59&" / "&kga!L60 but a box is opening that says "Update Values kga". What am I doing wrong? Thanks, Leah "T. Valko" wrote: Follow this syntax: =Sheet2!A1&" / "&Sheet2!B1&" / "&Sheet2!C1&" / "&Sheet2!D1 -- Biff Microsoft Excel MVP "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to combine multiple cells into on cell
I changed the name of the sheet to kga (lower case) and it worked
beautifully! I really appreciate your help, my boss is going to be thrilled! Leah "T. Valko" wrote: a box is opening that says "Update Values kga". That usually means the referenced sheet doesn't exist. Maybe you've misspelled the sheet name? -- Biff Microsoft Excel MVP "papercut" wrote in message ... I entered the formula as follows (my sheet is named KGA): =kga!L49&" / "&kga!L50&" / "&kga!L51&" / "&kga!L52&" / "&kga!L53&" / "&kga!L54&" / "&kga!L55&" / "&kga!L56&" / "&kga!L57&" / "&kga!L58&" / "&kga!L59&" / "&kga!L60 but a box is opening that says "Update Values kga". What am I doing wrong? Thanks, Leah "T. Valko" wrote: Follow this syntax: =Sheet2!A1&" / "&Sheet2!B1&" / "&Sheet2!C1&" / "&Sheet2!D1 -- Biff Microsoft Excel MVP "papercut" wrote in message ... I need to combine multiple cells on one worksheet into one cell on another worksheet. I also need the info to be seperated like this: info / info / info / info. Is there a way to do this and can it be explained in laymans terms??? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
| How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
| Combine multiple cells into one cell range. | Excel Worksheet Functions | |||
| combine text of multiple cells | Excel Worksheet Functions | |||
| How can I combine multiple cells in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
