• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Incorporating cells into a sentence

E

elsmith9035768

Member
I am trying to incorporate cells into a sentence. I've attached an example of how I have the tables organized. Anyone know of an easier, more efficient way to accomplish this task? There will be a total of 10 sentences when I am done. The final sentence is highlighted in yellow on the example.

The date and dollar amounts are not transferring to the sentence correctly. Anyone know how to get the date and dollar amounts to incorporate into the sentence correctly or why they are not transferring correctly?
 

Attachments

  • Incorporate cells in a sentence.xlsx
    10.3 KB · Views: 3
  • Incorporate cells in a sentence.xlsx
    10.3 KB · Views: 1
  • Incorporate cells in a sentence.xlsx
    10.4 KB · Views: 4
Code: 
=F16&G16&H16&TEXT(I16,"mm/dd/yyy") &J16&K16&" "&L16&M16&TEXT(N16,"$#,##0.00;[Red]£#,##0.00") &O16&F17&G17&H17&TEXT(I17,"mm/dd/yyy")&J17&K17&" "&L17&M17&TEXT(N17,"$#,##0.00;[Red]£#,##0.00")&O17
or
Code: 
=TRIM(F16&" "&G16&H16&" "&TEXT(I16,"mm/dd/yyy") &" "&J16&" "&K16&" "&L16&" "&M16&" "&TEXT(N16,"$#,##0.00;[Red]£#,##0.00") &" "&O16&" "&F17&" "&G17&H17&" "&TEXT(I17,"mm/dd/yyy") & " "&J17&" "&K17&" "&L17&" "&M17&" "&TEXT(N17,"$#,##0.00;[Red]£#,##0.00")&" "&O17)
 
Last edited:
You must log in or register to reply here.
Back
Top