adding text to a formula

[Howieg]

How to add text to a formula

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what text do you want & what is the formula?

 

[Candyman8019]

Are you looking for something like the following:
=A1+B1 & " Total Cans of Pears."