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.