Apr 08 2019 03:19 PM
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?
Apr 08 2019 04:52 PM
Hello @RCooper0206 ,
You can combine text and a formula this way
="Blood Sugar Average "&Average(A1:A7)
cheers,
Apr 09 2019 02:10 AM
@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.