|
|
|
|
#1
12-26-2017, 12:07 PM
|
|||
|
|||
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
12-26-2017, 02:06 PM
|
|||
|
|||
|
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
12-27-2017, 12:41 AM
|
||||
|
||||
|
Thank you for sharing your solution with us
__________________
Using O365 v2503 - 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 |
Windows 7 32bit 
Office 2003
Hybrid Mode