Thread: Text in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StephanieH
 
Posts: n/a
Default Text in formula

I want to display the sentence "Average Total Accounts: Oct - Apr"
based on a formula.
A23 = November-05
So far, I have the formula ="Average Total Accounts: "&TEXT(A23-1, "mmm")
which displays "Average Total Accounts: Oct", so I know I'm close.

Where I'm having a problem is adding the " - " between Oct and Apr and
adding the formula to display Apr.