text and formulas in one cell

steph · Feb 20th, 2002, 10:24 AM

I would like to have a cell that has text and equations.

ex. 60 books (12*30=360)(48*36=1728) total books 2088

I need to explain my final total in the text. Can I put formulas and text in one cell?

Juan Pablo González · Feb 20th, 2002, 10:27 AM

Your message isn't much clearer than the previous one, but try this, maybe it will help you understand.

="My text has " & (2*A1 + B1) & " some formulas"

Feb 20th, 2002, 10:27 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Your message isn't much clearer than the previous one, but try this, maybe it will help you understand. ="My text has " & (2*A1 + B1) & " some formulas" __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 10:24 AM	#1
steph New Member Join Date: Feb 2002 Posts: 2	I would like to have a cell that has text and equations. ex. 60 books (1230=360)(4836=1728) total books 2088 I need to explain my final total in the text. Can I put formulas and text in one cell?