Home

Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-412228%22%20slang%3D%22en-US%22%3EHelp%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-412228%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20insert%20the%20words%20%22Blood%20Sugar%20Average%22%20with%20a%20space%20then%20the%20Average%20of%20my%20Blood%20Sugar%20Average%20for%20the%20week%20on%20an%20Excel%20page.%20I%20know%20how%20to%20do%20the%20average%20part%2C%20but%20How%20do%20I%20get%20it%20to%20put%20like%20Blood%20Sugar%20Average%20120%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-412228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-412536%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-412536%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316756%22%20target%3D%22_blank%22%3E%40RCooper0206%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20combine%20text%20and%20a%20formula%20this%20way%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D%22Blood%20Sugar%20Average%20%22%26amp%3BAverage(A1%3AA7)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Echeers%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-415221%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415221%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316756%22%20target%3D%22_blank%22%3E%40RCooper0206%3C%2FA%3E%26nbsp%3B%2C%20another%20way%20you%20may%20apply%20custom%20format%20to%20your%20cell%20with%20average%20(press%20Ctrl%2B1%20on%20it)%20as%3C%2FP%3E%0A%3CPRE%3E%22Blood%20Sugar%20Average%20%22%23%2C%23%230.0%3C%2FPRE%3E%0A%3CP%3EIngeborg'%20variant%20is%20more%20flexible%20and%20transparent%2C%20but%20with%20custom%20formatting%20like%20this%20you%20may%20do%20further%20calculations%20with%20that%20cell%20as%20with%20any%20other%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E
RCooper0206
Occasional Visitor

I am trying to insert the words "Blood Sugar Average" with a space then the Average of my Blood Sugar Average for the week on an Excel page. I know how to do the average part, but How do I get it to put like Blood Sugar Average 120?

 

2 Replies

Hello @RCooper0206 ,

 

You can combine text and a formula this way

 

="Blood Sugar Average "&Average(A1:A7)

 

cheers, 

@RCooper0206 , another way you may apply custom format to your cell with average (press Ctrl+1 on it) as

"Blood Sugar Average "#,##0.0

Ingeborg' variant is more flexible and transparent, but with custom formatting like this you may do further calculations with that cell as with any other number.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies