Help Please

Copper Contributor

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.