Follow this general syntax:

="Text "&FORMULA&" text"

For example:

="Today is day "&DAY(NOW())&" of the month"

Returns:

Today is day 25 of the month

--
Biff
Microsoft Excel MVP


"mome" wrote in message
...
Hi:
Can I split a cell with text, then a formula, then with more text? If so
how?