Functions/Formulas in Excel 5 - Combine Text and Formulas in a Cell

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to combine text, cell references, functions, and formulas together all in one cell in Excel. This tutorial shows you how to make great use of text in conjunction with functions in Excel. You will learn to combine text and functions with the ampersand (&) character and when to use quotation marks. This is a great tutorial for those looking to improve their Excel skills.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• functions
• formulas
• excel
• text in excel
• ampersand

[pwl1980]

In order to have number in the sentence formatted I would add text() formula to the cell in the following way

=A1&"'s expenses were "&TEXT(SUM(B1:E1),"$#,##0.00")

[VickyVictoria79]

Genious - thank you!!