Results 1 to 3 of 3

Thread: Looking for a more efficient formula...

  1. #1

    Looking for a more efficient formula...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am using this formula and it works, but I know it is going to be limiting for my needs.
    ='Question 4'!C13&", "&'Question 4'!C14&", "&'Question 4'!C15&", "&'Question 4'!C16&", "&'Question 4'!C17&", "&'Question 4'!C18&", "&'Question 4'!C19&", "&'Question 4'!C20&", "&'Question 4'!C21&", "&'Question 4'!C22&", "&'Question 4'!C23

    What is a better way to write this formula, so if I have responses in 10 rows or 1000, it will work? I am trying to capture text results from a survey, bring all the responses into one field and include a comma between each response.

  2. #2
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    93
    Articles
    0
    Excel Version
    2013, 2016, O365
    Excel is awful at concatenating contiguous cells.
    It would be nice if we could use somethng like: =CONCAT.ALL('Question 4'!C13:C23,",")
    Unfortunately, no. Your formula is the only approach Excel can accommodate right now.
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  3. #3
    Ron, I appreciate the response. Disappointing to hear there is not a better way. However, nice to hear I am doing it correctly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •