how do i combine text and formula calculation in same cell

[gsm]

 

[T. Valko]

An example...

="Today's date is "&TEXT(NOW(),"mmmm d yyyy")

 

[Ms-Xl-Learner]

Assume that you have the data as per below format

A1 Cell
Goods

A3 to A6
600
800
900
200

=A1&" " &SUM(A3:A6)

The above formula combine the Value of A1 and Sum the values of A3:A6
and the combined result will be derived in the same cell.

=CONCATENATE(A1," ",SUM(A3:A6))

This formula also derive the same result which is yielded by the first
formula.

Hops this is what you want.

If this post helps, Click Yes!

 

[gsm]

Hi

This is a really good response .Many thanks!

 

[gsm]

Hi Biff

Many thanks for your reply. This really helps.

 

[T. Valko]

You're welcome. Thanks for the feedback!