#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
Got it.
Code:
=CONCATENATE(IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$D2),"",[PurchaseStatementTemplate.xls]Sheet1!$D2),IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$E2),"",[PurchaseStatementTemplate.xls]Sheet1!$E2)) |
#3
|
||||
|
||||
Thank you for sharing your solution with us
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Possible to combine 3 different workbooks? | markg2 | Excel | 5 | 11-14-2016 12:36 AM |
How to combine many paragraphs in one paragraph? | Jamal NUMAN | Word | 25 | 03-08-2013 04:31 AM |
Please help me to combine these code together | lbf200n | Word VBA | 3 | 12-09-2012 04:22 PM |
Combine two forms into one | lwisniewski | Word VBA | 3 | 12-24-2010 03:45 PM |
Combine pst files? | markg2 | Outlook | 2 | 04-26-2010 03:09 PM |