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

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

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

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

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

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

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

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

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