Joining strings and functions

Anyone know of a way to join a string with a native function within a single cell, without using macros?

This following is of course invalid, but should give an idea of what I’m after:

=CONCATENATE("Total: ",=SUM(E2:E250))

One equal sign = is enough

=CONCAT("Total: ";SUM(E2:E250))

El Perfecto, figured it was something simple. Thank you!

Better would be, to just calculate =SUM(E2:E250) in the cell and apply the desired number format to the cell and edit that to prefix it with "Total: " (including quotes), for example like

"Total: "0.00

This way the cell result type is still numeric and can be calculated with further.

3 Likes

Even better, thanks again guys. :+1: