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
|