Add text to calculated field. 2

[frankyberry]

Using Excel 2002.

I have a simple formula which adds up multiple columns ..

=SUM(A1:A84)

but is there a way to add a text string to the end result?

so my result would read something like "895 minutes"
(without the quotes)?

Thanks

 

[AnotherHiggins]

=SUM(A1:A84) & " Minutes"

But be aware that it is now a text string, not a number. So you can't do any math with it.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,
[tt]
=SUM(A1:A84)&" minutes"
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

If you wanted to use that cell in calculations, you could Format>Cells - Number Tab - Custom - Type textbox...
[tt][highlight white]
#" Minutes"
[/highlight][/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[frankyberry]

Thanks to both for the quick response and helpful tip!