Forum Discussion
Help Please
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
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.
Hello RCooper0206 ,
You can combine text and a formula this way
="Blood Sugar Average "&Average(A1:A7)
cheers,
