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


[TABLE="class: Table TableWordWrap SCXW92633088, width: 0"]
<tbody>[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]September 31,2017

[/TD]
[TD="bgcolor: transparent"]$25,000

[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]October 30, 2017

[/TD]
[TD="bgcolor: transparent"]$25,000

[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]November 31, 2017

[/TD]
[TD="bgcolor: transparent"]$25,000

[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]December 31, 2017

[/TD]
[TD="bgcolor: transparent"]$25,000

[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]January 31, 2018

[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]February 28,2018

[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]Total Expenditures

[/TD]
[TD="bgcolor: transparent"] $,100,000

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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