G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
An example...
="Today's date is "&TEXT(NOW(),"mmmm d yyyy")
="Today's date is "&TEXT(NOW(),"mmmm d yyyy")
M
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!
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!
G
gsm
Hi
This is a really good response .Many thanks!
This is a really good response .Many thanks!
G
gsm
Hi Biff
Many thanks for your reply. This really helps.
Many thanks for your reply. This really helps.
T
T. Valko
You're welcome. Thanks for the feedback!