Feedback by UserVoice

Excel Wizard

My feedback

  1. 643 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Wizard supported this idea  · 
  2. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Wizard supported this idea  · 
  3. 282 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Excel Wizard commented  · 

    Please try

    =INDEX(TRANSPOSE(FILTERXML("<b><a>"&SUBSTITUTE(TEXTJOIN("|",,A1:A5),"|","</a><a>")&"</a></b>","//a")),SEQUENCE(ROWS(A1:A5),LEN(A1)-LEN(SUBSTITUTE(A1,"|",))+1))

    Excel Wizard supported this idea  · 

Feedback and Knowledge Base