How to combine these formulas into one?

Microsoft Office Forums

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

Prev

Previous Post

Next Post

Next

#1

Old

12-26-2017, 12:07 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

How to combine these formulas into one?

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

How to combine these formulas into one?

Office 2003

Advanced Beginner

How to combine these formulas into one?

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel 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

« 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.