Text and Data in a single Cell combo

[Memar]

I want to write a formula and function which includes text and date as a desired result shown below in bold

Desired Result

Total Expenditures as of December 31, 2017 $100,000


The expenditures are keyed in a different sheet
Monthly Expenditures

Column A Column B

September 31,2017	$25,000
October 30, 2017	$25,000
November 31, 2017	$25,000
December 31, 2017	$25,000
January 31, 2018	0
February 28,2018	0
Total Expenditures	$,100,000

<tbody>
</tbody>

 

[Alice Morland]

How about this?
="Total Expenditures as of " &A1&" "& TEXT(B1,"$ ##,#")

The TEXT formula is to ensure the amount is displayed with the $ sign and the commas.

 

[Yongle]

or dates (not text) in cell A1
="Total Expenditures as of "&TEXT(A15,"mmm dd, yyyy")

$amount ignored (not in bold)

Your calendar is different to mine Sep 30 days, Oct 31 days, Nov 30 days

 

[shaowu459]

haha, you find something interesting