Kimberly -

Is there a particular reason for using only one cell?

Use 2 if you can. "Time Period:" in one formatted bold.

Text() in the next. Align and size as desired. Much easier.

....best, Hash

In article ,
"KimberlyC" wrote:

Hi,
Is there a way to add formatting to this formula to make the "Time Period: "
bold and leave the rest of it in regular text?

="Time Period: "& TEXT(From2,"mm/dd/yyyy")&" - "&TEXT(To2,"mm/dd/yyyy")

Thanks in advance for you help!!
Kimberly