Text And Formula

dantb

Active Member
Joined
Mar 20, 2002
Messages
358
Is it possable to have text included with a formula? I was wondering if I could have the word "Total" inserted somehow in the below formula. Thanks Dan

=SUM(E1+G1)
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi there

Yes, you can do it like this:

="Total "&SUM(E1+G1)

(use "+" when adding numbers but use "&" when adding text)

regards
Derek
 

dantb

Active Member
Joined
Mar 20, 2002
Messages
358
Thanks Derek: Works great, learn something new everyday. Thanks again Dan !
 

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
Alternatively you could use a custom number format such as:

"Total" #.0

This would have the advantage of keeping your sum formatted as a number.
 

Atom

New Member
Joined
Nov 11, 2005
Messages
30

ADVERTISEMENT

PA HS T,

That is a great alternative I wouldn't have thought of!
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234

ADVERTISEMENT

="Total "&SUM(E1+G1)

...& just to be pedantic, there's no need to do the explicit addition inside the sum():

="Total "&SUM(E1,G1)

or

="Total "&(E1+G1)

...would do.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
Office Version
  1. 365
Platform
  1. Windows
And to be even more pedantic you don't need the ().:)

="Total "& E1+G1
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,632
Messages
5,832,772
Members
430,166
Latest member
Nige Leeming

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top