Formula and text in the same Excel cell Solved

Question

Hello. I would like to know how to combine text and a formula in a single cell in Excel 2007?

Let me explain:

In a cell, I would like the text "Total:" and then the formula "=SUM(G8:G29)".

Thank you for your help

Configuration: Windows Vista Firefox 3.0.5

peji72 · Accepted Answer

Try: ="Total "&SUM(G8:G29). -- "If ellipses could talk, they could tell a lot of things!"

leptitjeune · Answer

Thank you. But now it no longer shows the symbol "€". What should I do?

peji72 · Answer

"Total "&SUM(G8:G29)&" €" -- "If the ellipsis could talk, they would have plenty to say!"

michel_m · Answer

Hello

with your cell containing the formula selected

custom-number-format
in type you enter:
"total: "# ##0.00 €

you can thus write other formulas based on this cell

Edit:<ital> excuse me, I didn't pay attention to the 2007 mention: the command is (if I remember correctly) custom-number-format (to be verified)</ital>
--
Best regards,
Michel

leptitjeune · Answer

Thank you both for helping me.

Formula and text in the same Excel cell

5 réponses

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french