• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Checkbox formula to combine text to make a paragraph.


New Member

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.


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!2024-06-12_20-13-58.jpg2024-06-12_20-14-17.jpg2024-06-12_20-15-02.jpg
Assuming that you are using the checkboxes in the Excel 365 Insider Beta, try:


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

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


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: