How can I make multple worksheet text all show in one box as a tot

N

NavyGunner

I am trying to get a cell on my last work sheet to haev all the text values
from 31 worksheets to show in a single box. IE sheet 1 box 1 says W1R, Sheet
2 box 1 says M1R, Sheet 3 says Y1R, I want Total sheet to say, "W1R, M1R,
Y1R". Is there a way to have that come up like that?
 
M

M Kan

You can use CONCATENATE (cell ref1, cell ref2, ...) to join a bunch of cells
values together.
 

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

Top