Microsoft Office Forums - View Single Post - [Solved] Combining several cells data into one single cell

Thread: [Solved] Combining several cells data into one single cell

View Single Post

Old

01-05-2017, 06:36 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

Code:

=if(A1=1,1,0)&if(B1=1,1,0)& ... &if(J1=1,1,0)

Reply With Quote