Need to combine multiple cells into on cell

P

papercut

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
 
L

Luke M

='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.
 
P

papercut

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
 
P

papercut

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
 
P

papercut

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

T. Valko

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?
 
P

papercut

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

obtaining info from multiple cells from different workbooks. 3
Combining text from multiple cells 6
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Formulas appear in cell instead of formula result 3
combining multiple columns using ", " seperations.. 4
setting multiple cells equal to other cells 2
Combining Cells 2
Info from one cell making other cells active 1

Top