Adding text to a formula in Microsoft Excel

ifonlyidknownthat

You want to have text and the result of a formula in the same cell; for example the cell should say “Total Sales Made: ” followed by the result of the calculation to work out annual sales.

Starting Point: Click in the cell in which you want the result.

Script:

Type an equals sign as all formulae start with an equal sign, then type in the required text enclosed within double apostrophes, in this case: “Total Sales Made: “ Now type in an ampersand (&) sign. Now enter the relevant formula, in this case SUM(B4:B25).

Press the Enter key.

Format the cell as required.

Find out more about our Excel training London, UK, or our Excel training Dorset, Wiltshire, Hampshire .

Find out more about our Excel training Sydney, Australia.

View original post

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s