combine worksheet cells

[atari2600]

For some reason I am can't seem to remember how to combine two different worksheet cells into one cell (text only - not arithmetic). If cell B5 says "Happy", and cell C5 says "Birthday", I'd like for Cell D5 to say "Happy Birthday".

I keep trying to find the right place to look for this, but keep getting stumped on the right operator in my formula.

Any help is greatly appreciated.

Matt

[michaelk]

=CONCAT(B5, ' ', C5)

[atari2600]

Perfect! Thanks!

[VincentCuclair]

How do I divide the contents of one column by the contents of another?

[michaelk]

=A1/A2

[VincentCuclair]

=A1/A2

Ah, not that simple , I need it to work for the values in each row....? Is it possible at all.

Basically, I have a list of all window types, each ID type is summed up however that means the Unit Heights and Widths are summed as well, I want these to show the size of one unit not all summed up.......capisce....

Edited October 26, 2012 by Vincent C

[michaelk]

Vincent

Capisce.

There's a trick!

Drag the sum to the column you want to summarize.

Then drag another sum to the column(s) you don't want to summarize. Not terribly intuitive.

If you look at the new 2013 summarized window schedule you can see how it's done.

example attached.

mk

[michaelk]

You would think that =(Window.Width)/COUNT would work. But it doesn't. I don't know why....

mk

[VincentCuclair]

Excellent Michael! No not so intuitive but useful, intuitiveness is wish listed:

http://needleandmortar.com/wiki/main-headline-wishlist-for-v2014/

Edited October 26, 2012 by Vincent C