How do you add text after a formula?

W

Weasel

I'm working on creating a report. At the top of each section is a mont
that I type in. At the bottom I want a cell to display that month an
also add the word "Total". So for example I have May listed in Cell B3
I now want "May Total" to be listed in cell B36. I know if I want it t
display just "May" I'd enter =B3 but how do I make it add the Tota
part? Thanks in advance for any help
 
B

Beege

Weasel said:
I'm working on creating a report. At the top of each section is a month
that I type in. At the bottom I want a cell to display that month and
also add the word "Total". So for example I have May listed in Cell B3.
I now want "May Total" to be listed in cell B36. I know if I want it to
display just "May" I'd enter =B3 but how do I make it add the Total
part? Thanks in advance for any help.
Click to expand...

Weasel,

Handy little ampersand will help

=B3&"Total"

Beege
 
Top