Thread: [Solved] How to combine these formulas into one?
View Single Post
 
Old 12-26-2017, 12:07 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to combine these formulas into one?
How can I combine the below 2 formulas into one Cell?
Code:
=IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$D2),"",[PurchaseStatementTemplate.xls]Sheet1!$D2)
Code:
=IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$E2),"",[PurchaseStatementTemplate.xls]Sheet1!$E2)
Note: Because I want to concatenate both cells text into one cell which is retrieved from another excel work book.
Reply With Quote