Functions/Formulas in Excel 5 - Combine Text and Formulas in a Cell
6:13
Added: 2 years ago
From: ExcelisHell
Views: 1,959
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!

  • In order to have number in the sentence formatted I would add text() formula to the cell in the following way

    =A1&"'s expenses were "&TEXT(SUM(B1:E1),"$#,##0.00")

    pwl1980 1 year ago

  • Genious - thank you!!

    VickyVictoria79 1 year ago

View all Comments »
Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more