1

I used the following formula to help create my solution and used a tilda as I can't find the code for a bullet. My question is how do I add a tilda to the beginning of the first response?

This is the formula:

={"A: PHYSICAL ACCOMMODATIONS: (if any)";arrayformula(substitute(U2:U,"., ",Char(10)&Char(126)&" "))}

This is how the data comes in:

Teachers will provide STUDENT with preferential seating, as needed away from distractions., Teachers will provide STUDENT with preferential seating, as needed near the teacher for reassurance., Teachers will provide STUDENT with preferential seating, as needed near positive role models.

This is how it looks with my formula:

Teachers will provide STUDENT with preferential seating, as needed away from distractions

~ Teachers will provide STUDENT with preferential seating, as needed near the teacher for reassurance

~ Teachers will provide STUDENT with preferential seating, as needed near positive role models.

This is how I want it to look (ideally I would prefer a bullet if possible:

~ Teachers will provide STUDENT with preferential seating, as needed away from distractions

~ Teachers will provide STUDENT with preferential seating, as needed near the teacher for reassurance

~ Teachers will provide STUDENT with preferential seating, as needed near positive role models.

Any help would be greatly appreciated.

Thanks, Pamela.

0

1 Answer 1

0

Use a string literal like "• " and if(len()), like this:

=arrayformula( 
  { 
    "A: PHYSICAL ACCOMMODATIONS: (if any)"; 
    if( 
      len(U2:U), 
      substitute("• " & U2:U, "., ", char(10) & "• "), 
      iferror(1/0) 
    ) 
  } 
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.