using text with a function

[J.W.]

How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

 

[Nick Hodge]

J.W

A formula like this will work

="Total "&B54/4.5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[KL]

In addition to previous replies, if you want to preserve the format of the
numbers you get you can use the TEXT() function:

="Total " & TEXT(B54/4.5,"0.00")

or

="Total " & TEXT(B54/4.5,"0.0%")

or

="Total " & TEXT(B54/4.5,"#,##0")

etc. etc.

Regards,
KL

 

[Aladin Akyurek]

You can also custom format the formula cell as:

"Total "0.00

 

[J.W.]

Thank you all, very helpfull and they worked the way I wanted.
Thanks!