combining cells with multiple choices

		Microsoft Office Forums > Microsoft Excel > Excel
combining cells with multiple choices

FAQ

Thread Tools

Display Modes

01-13-2017, 11:02 PM

xor

Windows 10 combining cells with multiple choices

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

If you use Excel 2016, and with

1 Mon
1 Tue
1 Wed
1 Thurs
1 Fri
1 Sat
1 Sun

in A1:B7 the following array formula:

=MID(CONCAT(IF(ISNUMBER(A1:A7),B1:B7&" + ","")),1,LEN(CONCAT(IF(ISNUMBER(A1:A7),B1:B7&" + ","")))-2)

will return

Mon + Tue + Wed + Thurs + Fri + Sat + Sun

Please remember that an array formula must be completed by holding down Ctrl and Shift before pressing Enter.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining several cells data into one single cell	H28Sailor	Excel	6	01-09-2017 06:00 AM
Combining 2 tables into 1 and use Table2's column widths (hoping for workaround dealing merged cells	CodingGuruInTraining	Word VBA	24	10-07-2015 07:48 PM
Drop down lisr with multiple choices	Richard121	Excel	1	02-17-2015 08:30 AM
Combining multiple bulleted lists	TigerDroppings	Word	2	03-09-2013 07:08 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 PM.