Enter the formula. Format>Cells>Custom, in the Type box, enter "text"
(replace text with your text)
If this is not what you mean, tell us what you're trying to achieve
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| How do I enter a formula in a text cell without changing the text?