How to combine these formulas into one?

		Microsoft Office Forums > Microsoft Excel > Excel
How to combine these formulas into one?

FAQ

Thread Tools

Display Modes

12-26-2017, 02:06 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to combine these formulas into one?

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

Got it.

Code:

=CONCATENATE(IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$D2),"",[PurchaseStatementTemplate.xls]Sheet1!$D2),IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$E2),"",[PurchaseStatementTemplate.xls]Sheet1!$E2))

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:47 PM.