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))
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.
Even better, thanks again guys.