Text and Data in a single Cell combo

Memar

Board Regular
Joined
Sep 2, 2011
Messages
76
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]



 
Last edited:

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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.
 
Upvote 0
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 :confused:
 
Upvote 0

Forum statistics

Threads
1,224,220
Messages
6,177,214
Members
452,764
Latest member
Mark1963

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top