Checkbox formula to combine text to make a paragraph.

[sypark]

Hi,

I'm relatively new to using Excel formulas and was wondering if you can help me with any pointers on how I can achieve the following:

Have a vertical list of checkbox items with short text for each field. The boxes that are checked are converted into longer text and combined into one long text/paragrath in one cell. Ultimately, I wish to create a paragraph with pre-set sentences, so I can copy and paste the final combined text into another document.

Any suggestions would be greatly appreciated.

Thanks,

Steve

 

[sypark]

Here's what I want to do... I wish to click the check boxes to place text next to it (already done). The ones that are checked get placed after one another in one field to the right. Thanks!

 

[sypark]

How can I write the code to get the combined text in D2?

 

[AliGW]

Assuming that you are using the checkboxes in the Excel 365 Insider Beta, try:

=TEXTJOIN(" ",,FILTER(B2:B6,A2:A6))

You don't need the commas in column B if you use this:

=TEXTJOIN(", ",,FILTER(B2:B6,A2:A6))

 

[AliGW]

Cross-posted: https://www.excelforum.com/excel-fo...-checkboxes-to-combine-text-in-one-field.html

 

[vletm]

sypark​

As You've read from two Forums

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

These rules are for everyone:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org