How would I go about creating a formula that contains both text and a formula? For example say I have the number 3000 in cell F4 and in cell F5 I want it to automatically fill in “The number is 3000.” Is this possible and if so how do I go about doing it?
